0

I created an Azure SQL managed instance using terraform in Azure Subscription A.

I am trying to copy the databases in an existing Azure SQL Server in Subscription B to the SQL Managed Instances I created in Subscription A.

How can I go about this? I cannot find any resource that addresses a similar issue.

1 Answer 1

0

I don't know of a direct copy method that would cover that combination, but could you not export to bacpac (stored as a blob in a storage account or if small enough for your link to deal with quickly as a local file) then import to the target location? Use either SSMS or the appropriate command line tools.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.