This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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 :)
Ah Many thanks (that seems a little odd?) (Unless I've used the term managed SQL incorrectly?)
If indeed it is not supported why would be the simpliest way to replicate under 500 tables from one Azure SQL DB to another per original note (i.e production to development)
many thanks
Yes my apologies its not a managed instance at all (!)
Just an Azure hosted SQL Database - my appologies
I updated my answer to provide you the documentation that states Azure Managed Instance is not supported,
To my knowledge you can use Replication. I updated my answer with that option. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/replication-between-two-instances-configure-tutorial?view=azuresql-mi
With such a large number of tables, maybe you can consider copying the database and later do some programing to get the delta, https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/database-copy-move-how-to?view=azuresql-mi&tabs=azure-portal
Not an Azure SQL Managed Instance. No problem. I am glad,
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.