Hi everyone,

I've manually provisioned a standard SQL Database - i think it's about 20 per month. Using the portal was fairly straightforward. However, I can delete the database through SQL Server Management studio and then re-create it using Code First without needing to go back into the portal.

So my question, when i do this, how do i tell Azure what pricing band to use for the new database i'm creating from code?

thanks,

Andrew

Hey Andrew,

I think this Stack Overflow Post will answer your question:

http://stackoverflow.com/questions/27617969/how-to-programatically-create-sql-azure-database-of-type-basic-standard-edition

or this post

https://social.technet.microsoft.com/Forums/office/en-US/7d7b5cd8-5878-4241-a674-33336010f081/set-service-tiers-when-create-azure-sql-database-from-vs-c-entity-framework?forum=ssdsgetstarted

• Edited by TigerMintMicrosoft employee 9 hours 9 minutes ago added a new link
• Proposed as answer by TigerMintMicrosoft employee 9 hours 9 minutes ago
• Unproposed as answer by TigerMintMicrosoft employee 9 hours 9 minutes ago

Hey Andrew,

I think this Stack Overflow Post will answer your question:

http://stackoverflow.com/questions/27617969/how-to-programatically-create-sql-azure-database-of-type-basic-standard-edition

or this post

https://social.technet.microsoft.com/Forums/office/en-US/7d7b5cd8-5878-4241-a674-33336010f081/set-service-tiers-when-create-azure-sql-database-from-vs-c-entity-framework?forum=ssdsgetstarted

• Edited by TigerMintMicrosoft employee 8 hours 59 minutes ago added a new link
• Proposed as answer by TigerMintMicrosoft employee 8 hours 59 minutes ago
• Unproposed as answer by TigerMintMicrosoft employee 8 hours 59 minutes ago

Hey Andrew,

I think this Stack Overflow Post will answer your question:

http://stackoverflow.com/questions/27617969/how-to-programatically-create-sql-azure-database-of-type-basic-standard-edition

or this post

https://social.technet.microsoft.com/Forums/office/en-US/7d7b5cd8-5878-4241-a674-33336010f081/set-service-tiers-when-create-azure-sql-database-from-vs-c-entity-framework?forum=ssdsgetstarted

• Edited by TigerMintMicrosoft employee Monday, March 23, 2015 10:06 PM added a new link
• Proposed as answer by TigerMintMicrosoft employee Monday, March 23, 2015 10:06 PM
• Unproposed as answer by TigerMintMicrosoft employee Monday, March 23, 2015 10:06 PM
• Marked as answer by Andrew Brook 19 hours 50 minutes ago

Hey Andrew,

I think this Stack Overflow Post will answer your question:

http://stackoverflow.com/questions/27617969/how-to-programatically-create-sql-azure-database-of-type-basic-standard-edition

or this post

https://social.technet.microsoft.com/Forums/office/en-US/7d7b5cd8-5878-4241-a674-33336010f081/set-service-tiers-when-create-azure-sql-database-from-vs-c-entity-framework?forum=ssdsgetstarted

• Edited by TigerMintMicrosoft employee Monday, March 23, 2015 10:06 PM added a new link
• Proposed as answer by TigerMintMicrosoft employee Monday, March 23, 2015 10:06 PM
• Unproposed as answer by TigerMintMicrosoft employee Monday, March 23, 2015 10:06 PM
• Marked as answer by Andrew Brook 20 hours 0 minutes ago

Hey Andrew,

I think this Stack Overflow Post will answer your question:

http://stackoverflow.com/questions/27617969/how-to-programatically-create-sql-azure-database-of-type-basic-standard-edition

or this post

https://social.technet.microsoft.com/Forums/office/en-US/7d7b5cd8-5878-4241-a674-33336010f081/set-service-tiers-when-create-azure-sql-database-from-vs-c-entity-framework?forum=ssdsgetstarted

• Edited by TigerMintMicrosoft employee Monday, March 23, 2015 10:06 PM added a new link
• Proposed as answer by TigerMintMicrosoft employee Monday, March 23, 2015 10:06 PM
• Unproposed as answer by TigerMintMicrosoft employee Monday, March 23, 2015 10:06 PM
• Marked as answer by Andrew Brook Tuesday, March 24, 2015 11:15 AM

Hey Andrew,

I think this Stack Overflow Post will answer your question:

http://stackoverflow.com/questions/27617969/how-to-programatically-create-sql-azure-database-of-type-basic-standard-edition

or this post

https://social.technet.microsoft.com/Forums/office/en-US/7d7b5cd8-5878-4241-a674-33336010f081/set-service-tiers-when-create-azure-sql-database-from-vs-c-entity-framework?forum=ssdsgetstarted

• Edited by TigerMintMicrosoft employee Monday, March 23, 2015 10:06 PM added a new link
• Proposed as answer by TigerMintMicrosoft employee Monday, March 23, 2015 10:06 PM
• Unproposed as answer by TigerMintMicrosoft employee Monday, March 23, 2015 10:06 PM
• Marked as answer by Andrew Brook Tuesday, March 24, 2015 11:15 AM

thanks for the response - that certainly clarifies the approach for specifying pricing band when creating a database. Must have just been using slightly incorrect terminology when i was searching for it myself ;)