Answered by:
Synchronization between 2 SQL 2008 with change tracking

Question
-
http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=1200
this example seems to work for SQL 2008 to an other version but not using Integrated change tracking
I want to work with Change tracking between 2 SQL 2008 databases.
I've tried to edit the code example, but i'm stuck
look at folowing codeDbServerSyncProvider serverSyncProvider = new DbServerSyncProvider(); SqlExpressClientSyncProvider clientSyncProvider = new SqlExpressClientSyncProvider(); SyncAgent syncAgent = new SyncAgent(); syncAgent.RemoteProvider = serverSyncProvider; syncAgent.LocalProvider = clientSyncProvider; It uses the SqlExpressClientSyncProvider, wich i don't want to uses, they write Change Tracking manually in it.(use guid, anchor table...)
So i tried to assign a DBServerSyncProvider & DBSyncProvider to the clientSyncProvider variable
but the problem is syncAgent.LocalProvider requires a clientSyncProvider wich is an abstract class..
anyone knows how you fix the code to work with Change Tracking on both sides?- Moved by Hengzhe Li Friday, April 22, 2011 5:36 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
Sunday, February 15, 2009 6:49 PM
Answers
-
I was able to get it working.
I have 2008 Server to SQL 2008 Express client, using native Change Tracking.
I have added additional complexity, so pasting the code here will require significant clean-up effort (no time - sorry), but you should be able to achieve it by using the example you're referring to, and modifying it according to this article:
How to: Use SQL Server Change Tracking
I was also able to modify my SQL Express provider to work with SqlSyncAdapterBuilder.
Giorgi- Proposed as answer by G.Stoynev Wednesday, February 18, 2009 2:16 PM
- Marked as answer by Liam Cavanagh - MSFTMicrosoft employee Friday, March 6, 2009 6:10 PM
Wednesday, February 18, 2009 2:15 PM
All replies
-
This one seems to be a duplicate post of
If an answer is provided, it will be posted on the other post.- Proposed as answer by Patrick S. Lee Monday, February 16, 2009 7:35 PM
Monday, February 16, 2009 7:35 PM -
I was able to get it working.
I have 2008 Server to SQL 2008 Express client, using native Change Tracking.
I have added additional complexity, so pasting the code here will require significant clean-up effort (no time - sorry), but you should be able to achieve it by using the example you're referring to, and modifying it according to this article:
How to: Use SQL Server Change Tracking
I was also able to modify my SQL Express provider to work with SqlSyncAdapterBuilder.
Giorgi- Proposed as answer by G.Stoynev Wednesday, February 18, 2009 2:16 PM
- Marked as answer by Liam Cavanagh - MSFTMicrosoft employee Friday, March 6, 2009 6:10 PM
Wednesday, February 18, 2009 2:15 PM