Azure Data Synch - Bulk Inserted records not synching

David Burt 26 Reputation points
2021-09-24T20:03:46.907+00:00

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 32,891 Reputation points MVP
    2021-09-24T20:52:19.397+00:00

    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