Database Reference
In-Depth Information
5.2 SQL Server Management Studio
With SSMS, the database administrator can manage and develop Windows Azure SQL Database
components. SSMS has many diferent editions. SSMS Express is a minimum edition that works
with Windows Azure SQL Database. For database administrators who have experience with SQL
Server, managing Windows Azure SQL Database with SSMS will be efortless. A number of GUI
tools are included in SSMS. On a client computer, SSMS can be used to connect to Windows
Azure SQL Database. SSMS includes a query editor that can be used to edit and execute T-SQL
statements, analyze SQL execution plans, and provide statistic information. SSMS allows the
database administrator to script out a database object such as a table or a user from one server to
another server. he database administrator can use SSMS to migrate databases from Windows
Azure SQL Database to an on-premises SQL Server with the tool Generate Script Wizard. When
connected to Windows Azure SQL Database, the database administrator can use the set of dialogs
provided by SSMS for database maintenance. he database administrator can also launch the
Template Explorer to use Windows Azure SQL Database templates to create database objects in
Windows Azure SQL Database. Figure 5.1 displays the components in SSMS.
he new SSMS for SQL Server 2012 has added features that can integrate Windows Azure into
an on-premises SQL Server. he new SSMS greatly simpliies data migration between Windows
Azure SQL Database and an on-premises SQL Server. Its code editor provides a new interface for
viewing XML results. In addition, the new SSMS also allows the database administrator to export
data to nonrelational data storage such as Blobs.
Figure 5.1
SQL Server Management Studio.
Search WWH ::




Custom Search