February 4, 2009 at 8:08 am
We are trying to move some legacy applications from one server to a clustered SQL 2000 environment. One of these applications in particular will take a very long time to move due to all the connection strings the developers will need to update. My boss wants to go ahead and start moving the other applications to the cluster and wants to copy the data at least nightly from one server to another. Is there a good way to have the databases sync nightly (or in real time) that will allow both copies to be accessible?
February 6, 2009 at 7:14 am
You can take a look at Merge replication.
-Roy
February 6, 2009 at 7:22 am
I believe that should do exactly what I am going for. Thanks!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply