MetaGuru
MetaGuru

Reputation: 43873

Copy data from one database to another?

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

Answers (3)

Matt Grande
Matt Grande

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

Justin Niessner
Justin Niessner

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

Mehrdad Afshari
Mehrdad Afshari

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

Related Questions