January 8, 2004 at 4:10 pm
Moving selected data from one server to another...
Say I have two servers and each has many databases on it.
Say 'Server1' has databases 'DBOneOne' and 'DBOneTwo';
and server 'Server2' has databases 'DBTwoOne' and 'DBTwoTwo'.
How can I move selected data from say 'Server2-DBTwoTwo-TableOne' to 'Server1-DBOneOne-TableOne'?
I am interested to know if there are any other options other than using DTS.
January 8, 2004 at 4:23 pm
This sounds to me like a scenario for merge replication. What kind of latency is acceptable? Do you need to be able to modify data on both servers? If not you could use Transactional or Snapshot replication instead. But if you are modifying data in both places then Merge replication is what you are looking for.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
January 11, 2004 at 5:06 pm
Like Gary said, replication might be a possibility. Are you using this as an N-tier design and will be running reports from the second server or is this strictly for disaster planning/recovery? If the latter, you might look at log shipping or standard T-SQL backup/restore commands.
HTH
------------
Ray Higdon MCSE, MCDBA, CCNA
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply