How to install SQL Server 2019 on Debian 9 and connect from SQL Server Management studio
3Installation guidance for SQL Server on Linux.
In this video we are going to see how to install microsoft sql server 2019 on Debian 9.
Make sure that you have Internet connection to download the dependent debian packages from repositories which is used by sql server 2019
Important Note: Ubuntu 16.04 packages are 100% compatible with Debian 9. So we used ubuntu 16.04 binaries. Debian 9 does not have packages from microsoft.
Download SQL Server 2019, ODBC drivers, Unix ODBC Drivers,MS-SQL Tools,MSSQL-CLI from below links.
Sql Server 2019 binary -- https://packages.microsoft.com/ubuntu/16.04/mssql-server-2019/pool/main/m/mssql-server/
Sql Server 2019 CLI -- https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/mssql-cli/
Install sqlcmd and bcp the SQL Server command-line tools on Linux
The mssql-tools package contains:
sqlcmd: Command-line query utility.
bcp: Bulk import-export utility.
MS SQL tools -- https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/mssql-tools/
Unix Odbc packages -- https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/u/unixodbc/
MS ODBC Driver -- https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/msodbcsql17/
We will be installing SQL Server 2019 Developer Edition on this video, which is full featured and free to use for development.
How to start/stop sql server service on Debian Linux:
systemctl start mssql-server.srevice
systemctl stop mssql-server.srevice
systemctl status mssql-server.srevice
#sqlserveronlinux #sqlserverdebian #sqlserver2019