Overview of Tools for Azure SQL
Database
There are several tools available
for managing Azure specific aspects and Database specific aspects.
Tools for managing Azure specific
aspects are:
- Azure Portal
- Azure PowerShell
- Azure CLI
- Azure Resource Managers
Templates
Tools for managing Database specific
aspects are:
- SSMS (SQL Server Management
Studio)
- SQLCMD
- Visual Studio
SSMS is an integrated tool for managing
any SQL infrastructure. SSMS is used to configure, access, administer,
implement and develop all components of SQL Server, Azure SQL Database, and SQL
Data Warehouse.
SSMS gets connected to your Azure SQL database and SQL server by
SQL Server connect authentication, which allows you to manage your SQL
infrastructure.
The SQL Server Management Studio Object Explorer component is
used to view and manage the objects in SQL server instances.
The SQL server object Explorer in Visual Studio
allows you to connect to your Azure subscription and its all database instances.
It enables the functionality of working directly in Visual
Studio from your Azure portal and makes it feel like a local database.
Command Line Tools for Azure
SQL Database
The Azure SQL database can be accessed through
command line tools such as PowerShell and SQLCMD.
Windows PowerShell contains the entire library of PowerShell
cmdlets in the UI itself, which are used for administering Azure SQL database.
PowerShell is specifically used for administering and automating
the database. This cannot help in querying the data.
Querying the data from the command line is provisioned
with SQL-CMD, which is a standard SQL command line administration
tool (command-line sequel query editor).
Comments
Post a Comment