803
Chapter 31: Managing Data in Windows Azure SQL Database
31
same thing applies for creating a database and other objects. The GUI interface for creating
SQL Database objects is missing. Is this coming? Certainly, but it is not known when.FIGURE 31-1
SQL Server Management Studio Connected to SQL Database.Windows Azure SQL Database Manager
A new tool to the playground is the SQL Database Manager (sometimes called SQL Database
Manager), a web-based and lightweight database management tool specifi cally designed
to enable a quick solution for developing, deploying, and managing their SQL Database
instances. This tool is available via the Windows Azure Platform Management Portal.The great thing about the SQL Database Manager is that it provides a GUI-driven mechanism
for creating and managing tables, views, and stored procedures in a SQL database. This is a
welcome tool because even though you can connect to SQL Database with SSMS, the wizard-
driven interfaces for creating objects such as tables and views are missing. In SSMS if you
right-click the Tables node for a given database and select the New Table option, you don’t
get the New Table dialog that you get when working with SQL Database. What you get is a
new query window with the syntax for creating a new table.SQL Database Manager fi xes this, providing a nice web-based and GUI-driven mechanism for
creating the SQL objects you frequently work with. Figure 31-2 shows the main page for the
SQL Database Manager.c31.indd 803c31.indd 803 7/31/2012 10:00:22 AM7/31/2012 10:00:22 AM
http://www.it-ebooks.info