Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

One of my Silverlight applications is running. This Application is using one central database (SQL Server 2008) and three other client databases (SQL Server 2008) in server other locations.

Our requirement is that with minor changing or without changing the Silverlight application, when we make changes in the central database (insert, update and delete in multiple tables) these changes automatically occur in all client databases. And when any change is made in any client database all client as well as central database should be updated automatically.

For this I read some about Sync Framework and SQL Server 2008 Change Tracking. But I have no idea about how will I do this. Please help me. How can we achieve this?

share|improve this question
1  
Have you looked into merge replication? This can be used to sync your different client SQL servers with the central SQL server. –  StanleyJohns Jul 7 '13 at 18:06
add comment

2 Answers 2

The out-of-the-box solution for this in SQL Server is Peer-to-Peer Transactional Replication. This requires Enterprise edition at all nodes.

If your application truly needs this architecture, I would strongly recommend using the built-in tools rather than trying to patch something together using another technology. Peer-to-Peer replication was designed for this exact scenario.

Having said that, I would recommend that you make sure this architecture is actually necessary, as opposed to having one centralized database. I'm not saying this is the case in your scenario, but sometimes the people in suits can try to dictate a solution like you're asking for, without fully understanding the technical complexity. Setting up and managing this type of replication can be challenging.

share|improve this answer
add comment

You can refer the below article to understand bit more on it. They have given some sample code as well.

Database Synchronization with the Microsoft Sync Framework

HTH

share|improve this answer
    
hi kat, thankyou very much for your time which u given to solve to my query.As i seen the code its working fine,but there is a concept of one local and one remote db..but in my case i need to update one local and many remote db...please help me i am unable to set my all remote db..is it done by coading??any function or property which i dont know. please reply –  aashish.dynamic Jun 19 '13 at 5:38
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.