Answered by:
Synchronising two SQL Express Databases with ADO.NET sync services in MSF2.0

Question
-
I am looking at developing a hub and spoke synchronisation scenario using the Microsoft Sync Framework 2.0 two synchronise two SQL Express Server Databases.
A lot of the examples on the web use the SqlCeClient and the visual studio wizard to generate the sync code. However, with the introduction of the new SQL server provider in the 2.0 framework I am looking for some examples of how to sync selected tables and columns from two SQL Express Databases (please from raw code, not using the Visual studio wizzards). I am also interested in any examples that also deal with conflict handling.
- Moved by Max Wang_1983 Thursday, April 21, 2011 10:54 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
Tuesday, October 20, 2009 2:30 PM
Answers
-
Hi,
Please look at the new Sync Framework v2.0 sample - Database Sync: Peer-to-Peer over WCF in the sync code gallery: http://code.msdn.microsoft.com/sync. It is coded with SqlCeSyncProvider for SQL CE store, but you can easily change it to SqlSyncProvider for SQL Express.
The SqlSyncProvider doesn't support SQL Server 2008 change tracking. A side metadata table will be created for each data table.
Thanks,
Dong
This posting is provided AS IS with no warranties, and confers no rights.- Proposed as answer by Dong CaoMicrosoft employee, Moderator Tuesday, October 27, 2009 5:45 PM
- Marked as answer by Dong CaoMicrosoft employee, Moderator Wednesday, October 28, 2009 5:01 PM
Tuesday, October 27, 2009 5:45 PMModerator
All replies
-
Join the club.Let me know if you'd like to collaborate offline.-SaroTuesday, October 20, 2009 11:08 PM
-
Hi -
We have just released the new version of the Sync Framwork ( which includes V3 for the Database providers). You can find a how-to and sample in that SDK. I have also pasted a How-to link on our msdn page.
http://msdn.microsoft.com/en-us/library/dd918848(SQL.105).aspx
Thanks
Deepa
Deepa ( Microsoft Sync Framework)Wednesday, October 21, 2009 11:03 PMAnswerer -
Hi
But im dont found new example using:
N TIER offline scenario,
(client side)SqlExpress with Sql Change Tracking
(server side) SqlExpress with Sql Change Tracking
Please help me.
Thursday, October 22, 2009 3:14 PM -
Hi,
Please look at the new Sync Framework v2.0 sample - Database Sync: Peer-to-Peer over WCF in the sync code gallery: http://code.msdn.microsoft.com/sync. It is coded with SqlCeSyncProvider for SQL CE store, but you can easily change it to SqlSyncProvider for SQL Express.
The SqlSyncProvider doesn't support SQL Server 2008 change tracking. A side metadata table will be created for each data table.
Thanks,
Dong
This posting is provided AS IS with no warranties, and confers no rights.- Proposed as answer by Dong CaoMicrosoft employee, Moderator Tuesday, October 27, 2009 5:45 PM
- Marked as answer by Dong CaoMicrosoft employee, Moderator Wednesday, October 28, 2009 5:01 PM
Tuesday, October 27, 2009 5:45 PMModerator