The Change Tracking feature of Sql Server allows to identify the modified rows of a modified database copy.
This is obviously helpful for sync jobs, as the database can then be synced incrementally.
My question is: Is there a tool that uses this feature to actually do incremental syncs?
I know about
- SSDT: can sync, but isn't interested in change tracking data as far as I know.
- MS Sync Framework: is a framework, I'm looking for an application.
Do I really have to write something myself?
Is there perhaps some cool SQL script that does that if the source is brought in as a linked server?