Copy database script in Azure Managed Instance connection

Question

Hi Team,   We are providing support for Azure Managed Instance in our application. We want to create database from existing database. 
Can you please help us providing the query for the same?
ex, For Azure SQL server authentication, we are using below script to create database from existing database,
"CREATE DATABASE DemoDB AS COPY OF SampleDB"
We need similar behavior in Azure Managed Instance.

Answer 1

Hi Sayali Khot (skhot),

Welcome to Microsoft Q&A forum.

As I understand, you want to Copy Database in Azure Managed Instance.

This could be done through 3 methods: Azure Portal, PowerShell and CLI as illustrated in the below link:

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/database-copy-move-how-to?view=azuresql&tabs=azure-portal#copy-or-move-database

As per the existing documentation, you can perform copies of Azure SQL Single and Pooled Databases only by COPY command https://learn.microsoft.com/en-us/sql/t-sql/statements/create-database-transact-sql?view=azuresqldb-current&preserve-view=true&tabs=sqlpool#database-copies

Refer to https://learn.microsoft.com/en-us/sql/t-sql/statements/create-database-transact-sql?view=azuresqldb-mi-current&preserve-view=true&tabs=sqlpool for Azure SQL Managed Instance.

Let us know if above information helped or you have a different ask.

Thanks

Answer 2

Hi @Sayali Khot (skhot)
It seems you're looking for a T-SQL command to copy a database in Azure Managed Instance, similar to what's available in Azure SQL Server. However, based on the documentation, currently, you can copy the database in SQL Managed Instance only using the Portal, PowerShell, or CLI.

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/database-copy-move-how-to?view=azuresql&tabs=azure-portal#copy-or-move-database Thank you!

Answer 3

Hi Sayali Khot (skhot),

Thanks for your patience.

I have checked with the internal team and Copy of Azure SQL Managed Instance could only performed by Azure Portal, CLI and Powershell.

It is not supported via TSQL.

However, if you feel this feature should be added and if it is feasible then I would suggest you to raise your Feedback over Azure SQL Database Community Feedback Channel where concerned team looks into the requests on the basis of importance and up-votes.

Hope this helps. Let us know if you have further queries. Thanks