Mittwoch, 1. August 2012 18:40
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?
- Bearbeitet BabiDesai Mittwoch, 1. August 2012 18:43 typo
Donnerstag, 2. August 2012 04:34Moderator
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.
- Als Antwort markiert BabiDesai Freitag, 24. August 2012 19:52