Overview: management tools for SQL Database
This topic explores and compares tools and options for managing Azure SQL databases so you can pick the right tool for the job, your business, and you. Choosing the right tool depends on how many databases you manage, the task, and how often a task is performed.
The Azure portal is a web-based application where you can create, update, and delete databases and logical servers and monitor database activity. This tool is great if you're just getting started with Azure, managing a small number of databases, or need to do something quickly.
For more in-depth information about using the portal see Manage SQL Databases using the Azure Classic Portal.
SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT) in Visual Studio are client tools that run on your computer and allow you to connect to, manage, and develop your database in the cloud. If you're an application developer familiar with Visual Studio or other integrated development environments (IDEs), try using SSDT in Visual Studio. Many database administrators are familiar with SSMS, which can be used with Azure SQL databases. Download the latest version of SSMS and always use the latest release when working with Azure SQL Database. For more information on managing your Azure SQL Databases with SSMS, see Manage SQL Databases using SSMS.
You must use the latest version of SQL Server Management Studio and SQL Server Data Tools for Visual Studio to remain synchronized with updates to Microsoft Azure and SQL Database. Older versions of these tools will not work successfully with SQL Database.
You can use command line tools such as PowerShell to manage databases and elastic database pools, and to automate Azure resource deployments. Microsoft recommends this tool for managing a large number of databases and automating deployment and resource changes in a production environment.
For more information on managing your Azure SQL Databases with command line tools, Manage SQL Database with PowerShell
Use the elastic database tools to perform actions such as