Some people like GUIs more than scripting languages. They can still manage to work with SQL Servers.
Databases reside in the database servers. These servers may reside on your laptops, computers running with various operating systems such as Windows, Linux, and macOS. These servers may run in the cloud such as Azure. The tools, however, may not reside on the same platforms but allows you to connect to the various above-mentioned servers.
In brief, the tools are the following:
1. Azure Data Studio uses the operating systems, Windows, macOS, and Linux
This tool can run on-demand queries and save data as text, JSON, or Exel. It has a lightweight editor
2. SQL Server Management Studio (SSMS)
It is a full-featured GUI as well as it can run TSQL statements. It has tons of features.
It is a one-stop database management tool.
It can connect to the cloud, Azure SQL Database, Azure Synapse Analytics, etc.
Developers and DBMs of all skill levels can use this tool.
3. SQL Server Data Tools(SSDT)
Using this you can build relational databases, Azure SQL databases, Analytical services, integration services, reporting services, etc
4. Visual Studio Code
Using the "mssql extension" for Visual Studio Code you can connect to SQL Servers
You can do scripting with a lightweight editor after connecting to SQL Server in Visual Studio.
You can find extensive references to complete articles on the following sisters blogs:
http://hodentekMSSS.blogspot.com
More on GUI tools here:
https://docs.microsoft.com/en-us/sql/tools/overview-sql-tools?view=sql-server-ver15
No comments:
Post a Comment