CODEWITHSUNDEEP
azureazure-sql-database
Davis
Davis

Reputation: 31

Moving Azure SQL to another subscription

I am planning to move my Azure SQL server and one database contained within it to another subscription, within the same tenant.

I did find a documentation online, which, surprisingly was 9 years old.

https://azure.microsoft.com/en-in/blog/moving-sql-azure-servers-between-subscriptions/

It doesn't tell what will be copied and what will not be copied. Does anyone know this, has anybody recently tried this move. Will the be schema be copied, but not the data in the database or is it not going to copy anything at all?

Any information on this is much appreciated.

Edit : I know about the "Move" button in the azure portal. Just want to know whether my data will also be moved. Been reading articles which say that i would lose the data.

Davis.

Upvotes: 0

Views: 889

Answers (1)

Martin Cairney
Martin Cairney

Reputation: 1767

It is as easy as going to the database in the portal and clicking on the Change Subscription link as highlighted in the below screenshot:

enter image description here

Upvotes: 1

Related Questions