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(102.4, 84%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Exploring options to schedule a restore or copy an Azure SQL Database to a SQL Server on Managed Instance (MI).
One known method is to export everything to a bacpac file and then importing it back to SQL MI. Looking at another other options and also best way to schedule this.
Thanks in advance.
![](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(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Below is a blog discussing database restoration with Automation. It covers the restoration process for both Azure SQL Server and managed instances
Please check if it helps in your scenario
Point number 4 in the blog- PowerShell commands to your runbook based on your Azure SQL resource type, if its Azure SQL database or Azure SQL managed instance.
Thank you!
Hello @RahulRandive Thank you for your response. I went through the blog. It only talks about restoring the database from Azure SQL db to Azure SQL db and Azure SQL Mi to Azure SQL Mi, which is good but, in my case, I am trying to restore an Azure SQL db to Azure SQL Mi. I tried a few variations of the PowerShell script but couldn't make it work. Thanks, Anoop
Hello @Anoop Noel Nakkala I'll suggest you to have a look to DBATools to copy Table-by-Table since native restore from Azure SQL DB to MI is not supported https://docs.dbatools.io/Copy-DbaDbTableData.html Regards Javier
![](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(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Hello @Anoop Noel Nakkala, Please let me know if you find above replies useful. If yes, please 'Accept the answer' for the above reply. This will help other community members facing similar query to refer to this solution.
Thanks,
Saurabh