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.