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 |
|
korcutt
Starting Member
2 Posts |
 Posted - 2008-07-08 : 17:30:20
|
| Howdy All, I have some tables that exists on two different servers. They are the same table definition. One server has a few records in the table and the other server has many more. I would like to merge the tables. In other words I would like to take all of the records that are on one server and insert them into the same table on the other server... I'm pretty sure this is a fairly easy taask via SQL, but as a Newbie, I don't have a clue!!! I'm only looking for the records that exists in the larger table and don't exists in the smaller table, and bring those records over... There might be ome records that match between the two tables... How might this be accomplished???Thanks in advance,Kevin Orcutt |
|
|
korcutt
Starting Member
2 Posts |
Posted - 2008-07-08 : 17:33:37
|
| Some additional Info: Both servers are Microsoft SQL Server 2005... One is my local box... the other I can access via the network...Thanks again, |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-08 : 18:22:50
|
| You can setup Linked server and insert records which are not in smaller table in other server. |
|
|
|
|
|
|
Merging Tables