Answered by:
Sync between two SQL Servers

Question
-
Hi,
I want to sync data between two SQL server databases (SQL server 2005) one is residing in US and another is in India. And the syncronization will be bidirectional. My questions are :
1) Is the Microsoft sync framework is good option for me?
2) If yes Which Provider should I use?
3)What type of communication should I use (WCF or any other like webservice/remoting)?
I am new to Microsoft Sync Framework, so please guid me in the proper direction.
Thanks in advance.
-Ajinath
Friday, May 14, 2010 9:14 AM
Answers
-
if you check the code, the client is communicating with the server/remote provider via WCF. the client never connects to the remote database directly.
in your scenario, you would have the WCF service installed on your remote site.
- Marked as answer by Dong CaoMicrosoft employee Friday, May 14, 2010 6:09 PM
Friday, May 14, 2010 12:27 PM
All replies
-
hi Ajinath,
Yes, Sync Fx may be a good option for you.
I would suggest you go with the peer-to-peer/collaboration providers.
have a look at this sample solution which synchronizes SQL Server over WCF using the peer-to-peer scenario: https://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3762
Friday, May 14, 2010 9:29 AM -
Hi JuneT,
Thanks for the information. I downloaded the application suggested by you but it seems that the destination sql server should be accessible from the source (location). But in my case the Sql servers will not be accessible to each other. So my question is how the source communicates to the destination?
I hope I dint confused you much.
-Ajinath
Friday, May 14, 2010 12:16 PM -
Look into N- tier over WCF (keywords)Friday, May 14, 2010 12:21 PM
-
if you check the code, the client is communicating with the server/remote provider via WCF. the client never connects to the remote database directly.
in your scenario, you would have the WCF service installed on your remote site.
- Marked as answer by Dong CaoMicrosoft employee Friday, May 14, 2010 6:09 PM
Friday, May 14, 2010 12:27 PM