Reputation: 43873
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 :(
Upvotes: 5
Views: 19058
Reputation: 12157
INSERT INTO new_db.dbo.TableA
SELECT * FROM old_db.dbo.TableB
If the tables are the same, this is probably the easiest way.
Upvotes: 14
Reputation: 245489
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.
Upvotes: 0
Reputation: 422252
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.
Upvotes: 4