I want to realize an offline scenario where client and server are SQL Server databases. Preferably with SQL Server Change Tracking.
Is that possible and a reasonable option at all?
From trying out it seems to me the only sql server to sql server sync is in collaboration mode and doesn't leverage sql server change tracking. (SqlSyncProvider & SqlSyncScopeProvisioning).
I'm wondering if i should continue or just use something like SQL Server Replication or roll my own Sync based on SQL Server change tracking. Might be less work and more control after all?
Scenario
- SQL Server database
- Filtering of rows to sync based on some filter queries
- +File Sync