Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

Sync data from one SQL 2005 DB to another one and then back?

I have a SQL 2005 database in two locations. I would like to be able to make changes and have them update the other DB on the other side on say Monday, and then have changes made after that on Wednesday sync back to the original.

I know that usually you're doing a replication where you have a master and slave, but would this be possible with a tool or script where you can go back and forth as long as it's not at the same time?
0
willlandymore
Asked:
willlandymore
  • 2
  • 2
1 Solution
 
lcohanDatabase AnalystCommented:
You could do that easily by running distributed queries through linked sql servvers or SSIS packages but it may be slow depending on what you need to do (query complexity), the volumes and link speed.

http://msdn.microsoft.com/en-us/library/aa172738(v=sql.80).aspx
http://www.sql-server-performance.com/tips/linked_server_p1.aspx
http://www.careerride.com/SQL-Server-Distributed-queries.aspx
0
 
willlandymoreAuthor Commented:
not sure if that will work for me. This is an application that is using the SQL 2005 DB on the backend so I can't really run the queries myself through SQL....
0
 
lcohanDatabase AnalystCommented:
Then in my opinion your best bet is Merge Replication.
0
 
willlandymoreAuthor Commented:
cool. I'll check that out.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now