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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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