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.

Rohit Gupta
2,1248 gold badges20 silver badges25 bronze badges
asked Jun 12, 2023 at 14:28

1 Answer 1

1

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.

J.D.
41.1k12 gold badges63 silver badges145 bronze badges
answered Jun 12, 2023 at 15:17

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.