Answered by:
sync services 2.0 and sql express

Question
-
Now that sync 2.0 has been released are there any examples that use sql express servers for syncing. I have seen the ctp provider sqlexpressprovider but I can only get it to work with version 1.0. Is there a provider that is specific to sql express released in version 2.0 framework?
- Moved by Max Wang_1983 Thursday, April 21, 2011 10:48 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
Thursday, October 29, 2009 4:38 PM
Answers
-
SqlSyncProvider can be use for SQL Server or SQL Server Express. You can take a look at one of the Database Synchronization Provider Samples listed in http://code.msdn.microsoft.com/sync. They implement the SqlSyncProvider sync with SqlCeSyncProvider.
Thanks,
Dong
This posting is provided AS IS with no warranties, and confers no rights.- Proposed as answer by Dong CaoMicrosoft employee, Moderator Thursday, October 29, 2009 5:46 PM
- Marked as answer by Dong CaoMicrosoft employee, Moderator Friday, October 30, 2009 4:37 PM
Thursday, October 29, 2009 5:46 PMModerator
All replies
-
Hi,
A new provider for collaboration scenarios is added in Sync 2.0 - SqlSyncProvider. You can use this new provider to sync Sql Express database. It cannot sync with the providers of offline scenarios, you need to use colloboration providers for both sides of your sync.
Thanks,
Dong
This posting is provided AS IS with no warranties, and confers no rights.- Proposed as answer by Dong CaoMicrosoft employee, Moderator Thursday, October 29, 2009 5:09 PM
Thursday, October 29, 2009 5:09 PMModerator -
Are there any specific examples of how to use the SqlSyncProvider with SqlExpress?
ThanksThursday, October 29, 2009 5:24 PM -
SqlSyncProvider can be use for SQL Server or SQL Server Express. You can take a look at one of the Database Synchronization Provider Samples listed in http://code.msdn.microsoft.com/sync. They implement the SqlSyncProvider sync with SqlCeSyncProvider.
Thanks,
Dong
This posting is provided AS IS with no warranties, and confers no rights.- Proposed as answer by Dong CaoMicrosoft employee, Moderator Thursday, October 29, 2009 5:46 PM
- Marked as answer by Dong CaoMicrosoft employee, Moderator Friday, October 30, 2009 4:37 PM
Thursday, October 29, 2009 5:46 PMModerator