Chapter 4. Creating and Managing a Windows Azure SQL Server Database

We're going to start building the database for our sales business domain, which will serve the customer website, administrator website, phone application, and order processor worker role. We'll cover the following topics:

• Creating a database in the portal
• Building the database using Entity Framework Code First Migrations
• Different tools for managing Azure SQL Servers and databases
• Backing up and restoring a database

Once we've covered these topics, we'll have complete local and Azure SQL databases and understand how to manage these databases using a number of different tools.

Note

Microsoft Azure services are continually expanding, improving, and changing, and Azure SQL Databases are no different. The Web and Business editions are due to be retired in April 2015, where they will be replaced with Basic, Standard, and Premium tiers, which will be available as a preview before then. These new tiers...