Azure SQL Database Management and Migration Tools

The Azure SQL Database service—Microsoft’s hosted relational database service—provides multiple tools for deploying, managing, and monitoring Azure SQL Database and for migrating data from on-premises to the service.

The Azure Management Portal allows customers to deploy databases, perform T-SQL commands, and monitor database utilization and performance.

SQL Server Management Studio, which is used to manage on-premises SQL Server, can also be used with Azure SQL Database deployments, providing an easier transition for staff moving to Azure SQL Database. These tools are available with the free SQL Server Express product, so customers are not required to buy the full SQL Server product to use them.

PowerShell Cmdlets are available to manage all aspects of Azure SQL Database deployments, similar to on-premises deployments with specific variations to address the cloud-hosted components of the service such as firewall and export features.

The Azure SQL Database Management API (a REST API) is a free interface that enables customers to write their own management routines for managing Azure SQL databases, servers, and firewall rules. For example, an application can include automated routines to modify the tier and performance levels of a database in response to specific changes in work loads, providing greater control over cost and performance.