Sync 2 SQL 2008 R2 database using change tracking and sync framework

Question

Hi,

I am trying to dveleop an application that involves 2 or more SQL database ( one local and other are remote). At sratup case, they all have the same data.

In case the server is unavaiable, the application tries to update the local database. It might be possible that multiple clients updates the same record ( with Guid as PK).

I am looking for the examples to sync these SQL 2008 databases using sync framework. I wanted to use the SQL 2008 change tracking to track the chnages and would not prefer to create extar tables of triggers.

all the examples that I look pointed to Sql Express or compact editiion.

Can you provide me one that sync 2 sql 2008 db using sync framework and chnage tarcking?

thanks



Answer 1

SQL Change tracking is only supported in the older offline providers which incidentally only supports SQL Ce as the client database.

if you want use Sync Framework to sync two SQL Server instances, you will have to use the newer provider SqlSyncProvider and that doesnt use the built-in SQL Change tracking.