Hello everyone, in the following article, I am going to discuss the SQL Server Management Tool for Linux. As you know, the popular Microsoft SQL Server is now available for Linux. We can easily install SQL Server on Linux and no need to install Windows Server. It is a great addition to Linux users who want to build their own SQL Server for their home or office. But the problem is that there are not many GUI Tool for SQL Server that runs on Linux. So in this article, I am going to review some SQL Server tools that work on Linux. Some of the software mentioned here in this post are free but also some other are paid software.
A. Azure Data Studio
Azure Data Studio is a free GUI database manager for Microsoft SQL Server. This is a free software by Microsoft and can be used to manage the local SQL Server or Azure database in the cloud. The functionality can be expanded by installing additional extensions. Azure Data Studio is available for Windows, Mac as well as Linux. We can also use this free program to backup and restore MS SQL Database.
Azure Data Studio Features:
- Built-in SQL Code Editor with Intellisense
- Smart SQL Code Snippet
- Customizable Server and Database dashboard
- Connection Manager
- Integrated Terminal
- Multi-platform supports
- Backup and restore database
B. SQL Server Management Studio (SMSS)
There is another free tool that can be used to manage the SQL Server. This tool is SQL Server Management Studio. Complex software that can be used to manage, design, configure, monitor, and administer the SQL Server. If you install SMSS, you will also install Azure Data Studio automatically.
For more detailed information about SQL Server Management Studio, please visit the following page:
https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-ssms?view=sql-server-ver15
To download, please use the link below
C. DBeaver Community Edition
DBeaver is a free, open-source universal database tool. It supports many kinds of databases such as SQL Server, MySQL, PostgreSQL, NoSQL, MongoDB, and many more.
DBeaver Community Edition features:
- Supports many databases
- Simple UI
- Free and open source
- Multiplatform
- Supports both local and cloud database
Download DBeaver Community Edition
For more features, I would recommend the DBeaver Pro.
Leave a Reply