Hi All,
I've got a write a program to copy the data from one database over to another. The destination database is empty(apart from the table names/columns) and is more or less the same as the old database BUT some columns have been removed from the tables and GUID fields have been added.
I can run SQL commands from in the development environment. What would be the best way to do it in SQL?
Thanks in advance.
Paul.
Not sure I understand. Best (and possibly only) way in SQL is to use a series of INSERT queries. If that's not the answer you were looking for, please clarify.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
September 21, 2023 at 1:00 pm
Hi Phil,
Yes, thank you. I've got it sorted now. I've gone with the INSERT INTO, SELECT route now.
Cheers
Paul.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply