Microsoft Sync Framework 2.1 + change tracking in Sql-Server 2008

When I provide scope for synchronization in SQL 2008 database as follows:

SqlSyncScopeProvisioning sqlServerProv = new SqlSyncScopeProvisioning(sqlServerConn, myScope); if (!sqlServerProv.ScopeExists(scopeName)) { sqlServerProv.Apply(); // Apply the scope provisioning. } 

I see a bunch of change tracking tables, stored procedures and triggers created. Why doesn't it use the SQL 2008 Change Tracking feature, which is much cleaner and everything is tracked behind the scenes? I thought the SQL 2008 Change Tracking feature was designed specifically to simplify these scenarios.

Now the question is: is there a way to do two-way synchronization between two SQL Server 2008 databases using only change tracking in both of them instead of providing triggers / auxiliary tables?

+4
source share

Source: https://habr.com/ru/post/1340706/


All Articles