Blog Post

Azure SQL Blog
8 MIN READ

How to automate Azure SQL Managed Instance database copy and database move operations

sasapopo's avatar
sasapopo
Icon for Microsoft rankMicrosoft
Jul 14, 2023
[Note (7/30/2024): The script in this blog has been edited to contain TargetSubscriptionId parameter, which should be used for cross-subscription copy and move operations. This parameter is supported...
Updated Jul 30, 2024
Version 12.0
azure sql
azure sql managed instance
EitanBlumin's avatar
EitanBlumin
Brass Contributor
Jul 18, 2023

Thanks for the response, sasapopo .

Yeah, the use case is fairly simple:

Daily "refresh" for a staging/historical database/sort of a "yesterday's snapshot" used for reporting.

As of today, we're using an Azure Automation runbook performing PITR for this purpose. But a dedicated Copy operation would've been preferable and more straightforward.