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.

Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 28,116 Reputation points MVP

    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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful