Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2011-03-25
4
Medium Priority
?
248 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
[X]
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
  • 2
  • 2
4 Comments
 
LVL 40

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 40

Accepted Solution

by:
lcohan earned 2000 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

715 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