CODEWITHSUNDEEP
azureazure-sql-database
user992867
user992867

Reputation: 65

Azure Import Data Tier Application does not have Standard DB option

I created the backup of my live Azure DB using Export option in Azure Portal. I am trying to restore this DB on my staging Azure DB using "Import Data Tier Application". The options listed under Azure DB Editions are Web and Business as shown in screenshot. However I need to create a Standard DB.

Is there a way I can create Standard Azure DB using "Import Data Tier Application"?

Azure DB Editions

Upvotes: 1

Views: 294

Answers (2)

Boboyum
Boboyum

Reputation: 708

This problem was addressed in an updated version of SSMS which you can find in the link below. The SSMS is also in a new stand alone installer now:

https://msdn.microsoft.com/en-us/library/mt238290.aspx

enter image description here

Upvotes: 1

Ansary Ans21
Ansary Ans21

Reputation: 462

I couldn't find such option in my ssms right now. You can choose web or business and import. after importing, change the service tier from the portal to 'standard'.

Upvotes: 0

Related Questions