Copying an old database to a new database

  • 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.


  • 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.

  • Hi Phil,

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



Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply