Managing SQL Azure Servers and databases

Although we've just built our database using EF Code First Migrations, we still need to be able to view and sometimes modify our data and also perform activities such as adding users or creating federations.

To do this, we have a number of tools available:

  • The SQL management portal
  • SQL Server Management Studio (SSMS)
  • Visual Studio SQL Server Object Explorer
  • The PowerShell console

Managing a database through the portal

We're going to take a look at managing a database through the management portal:

  1. In the database workspace, select the database we just created and click on MANAGE on the bottom toolbar:
    Managing a database through the portal
  2. We should see ...

Get Learning Microsoft Azure now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.