Azure SQL Data Sync is not supported on Azure SQL Managed Instance. See text highlighted in blue here.
Please consider to use Replication instead. Here is the documentation about replicating data between two managed instances.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi Folks,
We have 2x Azure Managed SQL Databases - both in the same instance.
DB-A (Production)
DB-B (Development / test)
I am attempting to use a Databse Sync group to replicate the content from DB-A to DB-B for testing.
As DBA-A has over 500 tables I've already created the appropriate differing log in / user and set permissions to that it can only "see" 491 of the tables - All good there.
Challenge comes with I run the Sync group - the following errors are producted in the log
I've already
DB-A
Database provisioning failed with the exception "SqlException ID: fbf8435a-fee6-4804-afc6-272aa45ac120, Error Code: -2146232060 - SqlError Number:15247, Message: User does not have permission to perform this action. SqlError Number:2759, Message: CREATE SCHEMA failed due to previous errors. For more information, provide tracing ID ‘8f643c97-db2c-4b54-ad56-5cd68df7ab44’ to customer support."
DB-B
Database provisioning failed with the exception "SqlException ID: 9fc7d19a-a48f-4c89-bac6-4cc77b21ecf0, Error Code: -2146232060 - SqlError Number:15247, Message: User does not have permission to perform this action. SqlError Number:2759, Message: CREATE SCHEMA failed due to previous errors. For more information, provide tracing ID ‘f4edbcc7-5b7e-4685-8082-c2d20b9dd500’ to customer support."
My SQL knowledge is very basic so appreciate any insight
Many thanks :)
Try to use the SQL Admin you defined when created the Azure SQL databases for the provisioning and SQL Data Sync setup. If you are using an account with less permissions, please make sure the account has the following permissions: Create/Alter Table, Alter Database, Create Procedure, Select/ Alter Schema, Create User Defined Type.