<div>
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.<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/aa172738(v=sql.80).aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/aa172738(v=sql.80).aspx</a><br />
<a href="http://www.sql-server-performance.com/tips/linked_server_p1.aspx" rel="ugc">http://www.sql-server-performance.com/tips/linked_server_p1.aspx</a><br />
<a href="http://www.careerride.com/SQL-Server-Distributed-queries.aspx" rel="ugc">http://www.careerride.com/SQL-Server-Distributed-queries.aspx</a>
</div>


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://msdn.microsoft.com/en-us/library/aa172738(v=sql.80).aspx]
http://www.sql-server-performance.com/tips/linked_server_p1.aspx [http://www.sql-server-performance.com/tips/linked_server_p1.aspx]
http://www.careerride.com/SQL-Server-Distributed-queries.aspx [http://www.careerride.com/SQL-Server-Distributed-queries.aspx]

<div>
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....
</div>


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....

<div>
<div class="content wysiwyg-content">
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. <br />
<br />
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?
</div>
</div>


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?

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

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.