I have an Azure SQL Database I have Azure SQL Data Sync that syncs that data to an on prem sql database
I want to call the sync group to execute instead of waiting for the sql data sync time to occur. Mainly because i dont want the sync to happen during a bulk insert.
my idea is to use a logic app to monitor a bulk insert and call the sql data sync but that isnt that easy
i see that LA can be activated on db changes
https://docs.microsoft.com/en-us/azure/connectors/connectors-create-api-sqlazure
i see there is supposed to be a rest api for data sync
https://azure.microsoft.com/nb-no/blog/azure-sql-data-sync-refresh/ (but i dont find any documentation on this)
i see a powershell script that i could use (maybe)
but... having i dont see an easy way to wire this all together as i dont see LA using powershell, i dont see SDS using rest, so no posting from LA.
If anyone has a better idea then please let me know. Its important to wait until a bulk insert of a table is complete before a sync starts to avoid errors. the data is only flowing from Azure to on prem.