Search code examples
azuremicrosoft-sync-frameworkazure-data-sync

Will SyncFramework work without local tracking tables?

I'm wanting to know if syncframework will work without using local tracking tables. Azure tracking tables are ok and we're just uploading to Azure.

Reason is some of our clients db's aren't owned by us so we can't really be adding tables / increasing their size.

thanks,

Solution

  • the tracking table is for recording what has changed. in your case, you actually needed it on local. Sync Fx will still provision the tracking tables in Azure though, useless if your Azure is never the source during sync.

    minimum OS requirement for Azure Data Sync Agent is Vista or above.

    you can get away without tracking tables using or writing a custom provider using the older offline provider model. however, you'd still need tombstone tables to record the deletes.