2

We have two subscriptions (DEV and PROD). A database server has been deployed to the DEV subscription, but it is now in use by our production system. I want to move the Azure SQL database server to the PROD environment.

I have owner privilege on both the DEV and PROD environment, but when I try to move the Azure SQL Server then the PROD environment doesn't show in the list of subscriptions. This feature has been implemented in 2012 and I do see the 'subscriptions' combo, so I think it should be possible. Anyone has a hint?

Improve this question
2
  • 1
    have you added in the subscriptions under the same account blogs.msdn.microsoft.com/mast/2013/02/03/…
    – Sum1sAdmin
    Apr 26, 2016 at 10:37
  • You're right... The problem is that the two subscriptions use a different Azure directory. I probably need to move the subscription to the same directory.
    – Ramon de Klein
    Apr 26, 2016 at 12:20

2 Answers 2

Reset to default
0

Easiest way I found was Export to Blob from the source database

SQL Database Options

Transfer the file from One subscription to another blob storage on the target subscription

Then on the target SQL Server Import the database from the blob storage

SQL Server Options

Improve this answer
1
  • On Stack it is preferred that you describe the solution completely within the answer so that even if the referenced link or pictures are removed that the information will remain available. Simply creating your own pictures is not a substitute to accurately describing the solution. If you pull information out of a source document it is appropriate to provide and attribution link to that source.
    – Rowan Hawkins
    Oct 2, 2020 at 11:49
-3

Hope you have fixed this issue, in case if you still need a help. please follow the below link https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-move-resources

Improve this answer
0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .