Copying an old database to a new database

• paul 69259

  Hall of Fame

  Points: 3068

  More actions

  September 21, 2023 at 10:26 am

  Go to Answer

  #4290992

  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.

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  September 21, 2023 at 12:57 pm

  Answer

  #4291076

  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.

  ---

• paul 69259

  Hall of Fame

  Points: 3068

  More actions

  September 21, 2023 at 1:00 pm

  #4291093

  Hi Phil,

  Yes, thank you. I've got it sorted now. I've gone with the INSERT INTO, SELECT route now.

  Cheers

  Paul.