%3CLINGO-SUB%20id%3D%22lingo-sub-682907%22%20slang%3D%22en-US%22%3EHow%20To%3A%20Move%20your%20Azure%20Data%20Warehouse%20to%20a%20new%20region%20and%2For%20subscription%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-682907%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20functionality%20currently%20does%20not%20exist%20to%20move%20your%20Azure%20SQL%20Data%20Warehouse%20instance%20to%20a%20subscription%20other%20than%20the%20one%20it%20was%20created%20under.%20What%20you%20can%20do%20is%20move%20the%20server%20that%20contains%20the%20instance%20to%20another%20subscription%20or%20resource%20group.%20Moving%20a%20server%20will%20move%20all%20Databases%20owned%20by%20that%20server%20to%20the%20destination%20subscription.%20The%20only%20limitation%20is%20that%20both%20subscriptions%20must%20exist%20within%20the%20same%20Active%20Directory%20Tenant.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20process%20will%20be%20slightly%20different%20depending%20on%20if%20you%20are%20simply%20moving%20an%20existing%20DW%20instance%20to%20a%20different%20subscription%20or%20if%20you%20wish%20to%20create%20a%20copy%2C%20or%20if%20you%20wish%20to%20move%20across%20regions.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3E%26nbsp%3BTo%20move%20an%20existing%20server%20and%20Data%20Warehouse%20to%20a%20new%20subscription%20without%20changing%20region%2C%20simply%20follow%20the%20instructions%20%3CA%20title%3D%22Move%20resources%20to%20new%20resource%20group%20or%20subscription%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Fazure%2Fazure-resource-manager%2Fresource-group-move-resources%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E.%3C%2FLI%3E%0A%3CLI%3ETo%20create%20a%20copy%20of%20an%20existing%20Data%20Warehouse%20or%20move%20the%20Data%20Warehouse%20to%20a%20new%20region%2C%20you%20will%20need%20to%20add%20in%20a%20geo-restore%20of%20the%20instance%3CUL%3E%0A%3CLI%3E%3CA%20title%3D%22Restoring%20Azure%20SQL%20Data%20Warehouse%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-data-warehouse%2Fsql-data-warehouse-restore%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ERestore%3C%2FA%3E%20the%20Data%20Warehouse%20to%20a%20new%20server%20in%20the%20same%20subscription%2C%20but%20in%20the%20desired%20destination%20region%3C%2FLI%3E%0A%3CLI%3E%3CA%20title%3D%22Move%20resources%20to%20new%20resource%20group%20or%20subscription%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Fazure%2Fazure-resource-manager%2Fresource-group-move-resources%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMove%3C%2FA%3E%20the%20new%20server%20owning%20the%20Data%20Warehouse%20to%20the%20desired%20subscription.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20same%20technique%20in%20no.2%20above%20can%20also%20be%20used%20if%20you%20wish%20to%20move%20a%20single%20instance%20or%20a%20subset%20of%20instances%20instead%20of%20every%20database%20owned%20by%20a%20server.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20have%20any%20issues%20with%20this%20approach%2C%20feel%20free%20to%20contact%20us%26nbsp%3B%40%20%3CA%20title%3D%22Help%20%2B%20Support%20blade%22%20href%3D%22https%3A%2F%2Fms.portal.azure.com%2F%23blade%2FMicrosoft_Azure_Support%2FHelpAndSupportBlade%2Foverview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Esupport%3C%2FA%3E%20any%20time!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-682907%22%20slang%3D%22en-US%22%3E%3CP%3EMoving%20an%20Azure%20SQL%20Data%20Warehouse%20databases%20is%20a%20more%20common%20task%20than%20one%20might%20think.%20But%20is%20also%20simpler%20than%20one%20might%20think.%3C%2FP%3E%0A%3CP%3ESee%20this%20refreshed%20article%20for%20details%20on%20the%20steps%20to%20take.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-682907%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESynapse%20Administration%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESynapse%20SQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESynapse%20Support%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E

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 Databases owned by that server to the destination subscription. The only limitation is that both subscriptions must exist within the same Active Directory Tenant. 

 

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.

 

  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
    • Restore the Data Warehouse to a new server in the same subscription, but in the desired destination region
    • Move the new server owning the Data Warehouse to the desired subscription.

 

The same technique in no.2 above can also be used if you wish to move a single instance or a subset of instances instead of every database owned by a server.

 

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