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?
LVL 1
willlandymoreAsked:
Who is Participating?
 
lcohanDatabase AnalystCommented:
Then in my opinion your best bet is Merge Replication.
0
 
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
 
willlandymoreAuthor Commented:
cool. I'll check that out.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.