Copy data from one database to another?

Question

I am upgrading a clients app to a newer version, the databases are close but slightly different. I need to figure out a way to transform and copy the data from one table in one database to another table in the new database. Oh geez :(

Answer 1

SQL Server Integration Services (previously known as Data Transformation Services) is the way to go.

SQL Server Import and Export data wizard works for simple tasks pretty well.

Answer 2

SQL Server Integration Services is going to be your best bet. If you're familiar with the SQL 2000 DTS Packages, you shouldn't have too much difficulty figuring out SSIS packages.

Answer 3

INSERT INTO new_db.dbo.TableA
SELECT * FROM old_db.dbo.TableB

If the tables are the same, this is probably the easiest way.