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 |
|
kowani1
Starting Member
42 Posts |
 Posted - 2007-02-20 : 18:09:23
|
| Hi All,I got two separate copies of Table 'MyTable' on database 'myDB' running on two servers; ServerX and ServerY - both SQL Server 2000+SP4. i.e. ServerX.MyDB.MyTable and ServerY.MyDB.MyTableI need to append all the records of 'MyTable' on serverX to the copy of 'MyTable' on server Y so that I have a complete records set. I have tried using the data-export/import wizard - which seems to run OK, but the record count is still indicating the old totals on destination server.Is there another way I can copy the data over.??Jungle Dba |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-02-20 : 18:15:19
|
| Create a linked server on the server you want to import to. Then simply run an INSERT ... SELECT using the four part name to select the data from the table on the linked server.server.database.owner.table |
 |
|
|
kowani1
Starting Member
42 Posts |
Posted - 2007-02-20 : 19:25:33
|
| thanks a lot. It's working OK.. |
|
|
|
|
|
|
Merging Data from Two Differents Servers