How To: Move your Azure Data Warehouse to a new region and/or subscription

This post applies to Azure SQL Data Warehouse

The functionality currently does not exist to move your Azure SQL Data Warehouse instance to a subscription other than the one it was created under.  What you can do is move the server that contains the instance to another subscription or resource group.  Moving a server will move all SQL Databases owned by that server to the destination subscription.  The only limitation is both subscriptions must exist within the same Active Directory Tenant.  The link below stats how to determine what tenant a resource belongs to.

 

The process will be slightly different depending on if you are simply moving an existing DW instance to a different subscription or if you wish to create a copy or if you wish to move across regions.

Process

  1. To move an existing server and Data Warehouse to a new subscription without changing region simply follow the instructions here
  2. To create a copy of an existing Data Warehouse or Move the Data Warehouse to a new region you will need to add in a geo-restore of the instance
    1. Restore the Data Warehouse to a new server in the same subscription in the desired region
    2. Move the new server owning the Data Warehouse to the desired subscription

 

If you have any issues with this approach feel free to contact us @ support any time!