Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Can I use SQL Server Integration Services (SSIS) to create a two-way synchronization between tables in two different databases? I am using SQL Server 2008 R2.

If it is possible, then how do I handle synchronization conflicts?

share|improve this question
add comment

2 Answers

up vote 0 down vote accepted

I would say that it is definitely possible. I am not sure that it would be the best option and any synchronization conflicts will need to be handled explicitly by your programming. I would consult MSDN first and read up on High availability solutions and Disaster Recovery before I went any further.
MSDN High Availability Overview

Disaster Recovery

Sql Server Installation Planning

share|improve this answer
    
Thanks for the links –  Jan Aagaard Sep 1 '10 at 8:03
add comment

Can I use SQL Server Integration Services (SSIS) to create a two-way synchronization between tables in two different databases? I am using SQL Server 2008 R2.

SSIS is a framework for doing ETL / Data Load jobs. What they do is your problem, not SSIS. So, you CAN do it, but YOU have to do it. 2 way sync is definitely challenging and not a standard ETL thing.

If it is possible, then how do I handle synchronization conflicts?

In whatever way you decide to handle them, which will be determined by how you MUST handle them per logic. SOme fields just are last entry wins. Some need elaborate logic. 2 way sync is challenging, and this needs to be determined by the programmer / architect on a case by case basis.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.