Microsoft Azure – Management Interfaces for Azure SQL
In this article, we will look into the management interfaces for Azure SQL. There are different ways to interact with Azure SQL. One of those ways is the Azure portal, and the below image shows the Azure SQL unified experience where Azure tried to ease the process of decision-making for users(ie, what to use when) into the portal itself.
Azure makes sure you have the tools you need. Many of you reading this are used to SQL Server Management Studio.SQL Server Management Studio is completely compatible with Azure SQL database and Managed Instance. In fact, Azure Management Studio understands it’s talking to an Azure SQL database and provides all of the options you need.
In addition, there is a new tool called Azure Data Studio. It’s cross-platform and open-source. Fully compatible to work with both Azure SQL database and Managed Instance, providing all the same functionality you would get if you’re using a SQL Server.
Finally, many users are command-line driven. All of Azure’s tools and interfaces that you’re going to use are going to be supported across any client operating system you need. The T-SQL language is also available which is used frequently. Several different T-SQL differences from a management interface like alter database, that makes sense just for Azure SQL.
In addition, PowerShell and Azure CLI are available to you for many different management operations, and the core of actually talking to Azure, both across the Azure ecosystem and Azure SQL Database and Managed Instance is a REST-API. So you can even go to the REST level to do various management operations for Azure SQL.
Then finally, for those of you who are command-line driven, no SQL command and BCP, these tools are very compatible to use on your client or even an Azure virtual machine to talk to Azure SQL.
You’ve got the portal which is new to you maybe, but it’s going to be a lot of different options to do many different things to manage Azure SQL, you got the familiar tool of management studio, the new Azure Data Studio, lots of command line choices, the T-SQL language. Azure gives you just about everything you need to manage Azure SQL resources.