SQL Data Sync relies on triggers that are added by the Microsoft Sync Framework. By default triggers do not run during a bulk insert. You must explicitly turn them on in the BULK INSERT command with the FIRE_TRIGGER option.
Azure Data Synch - Bulk Inserted records not synching
David Burt
26
Reputation points
I am using the Azure Data Synch tool to synch data from an Azure SQL DB to On Prem. In general it is working.
On one table when a bulk insert is done the bulk inserted records do not synch from the azure hub database down to the on prem database.
The initial synch on that table completed successfully.
If I manually insert a record into the table it synchs correctly.
If I do a trivial update on the bulk inserted records then the records will synch as well.
So it is only the bulk insert that is a problem.