Best Practices for Azure SQL DataSync 2.0 tasks

The Azure SQL DataSync workflow is carried by different tasks at different stages. The first task is to provision destination databases (Initial Synchronization). Then data changes (update/insert/delete) are propagated to the destination by sync tasks. If any changes are made in dataset or schema, re-provisioning occurs. Deprovisioning is engaged when a database is removed from…

0

Errors Configuring Azure SQL DataSync 2.0 agent

When adding an on-premise member database to a datasync 2.0 sync group, you will need to configure the local sync agent following these steps: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-get-started-sql-data-sync Sometimes, the you may run into errors. Error Type 1: “Submitted agent key is invalid. The agent key could not be parsed as expected. Please resubmit a valid agent key”…

0