Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vicpal25
Starting Member
21 Posts |
 Posted - 2008-02-25 : 12:21:19
|
| I have an existing table on a database on a different server (server22) with existing data. Now, I created the same table structure in a different server (server17). What is the best approach to transfer/migrate that data into the newly created table? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-25 : 12:28:40
|
| You can use linked server method or SSIS export/import wizard for transfering data. or even use distributed queries using OPENNROWSET. |
 |
|
|
vicpal25
Starting Member
21 Posts |
Posted - 2008-02-25 : 13:10:07
|
| I wound up using a simple INSERT INTO TableName (columnname, columnname) SELECT columnname, columnname FROM MY SERVER.DATABASE.DBO.TABLENAMEThanks for the input! |
|
|
|
|
|
|
Migrating data from server to server