Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2011-03-25
4
226 Views
Last Modified: 2012-05-11
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
Comment
Question by:willlandymore
  • 2
  • 2
4 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 35218286
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
 
LVL 1

Author Comment

by:willlandymore
ID: 35218531
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
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 35218600
Then in my opinion your best bet is Merge Replication.
0
 
LVL 1

Author Comment

by:willlandymore
ID: 35220381
cool. I'll check that out.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question