![]() The following steps use sqlcmd to locally connect to your new SQL Server instance. To make sqlcmd/bcp accessible from the bash shell for interactive/non-login sessions, modify the PATH in the ~/.bashrc file with the following command: echo 'export PATH="$PATH:/opt/mssql-tools/bin"' > ~/.bashrc To make sqlcmd/bcp accessible from the bash shell for login sessions, modify your PATH in the ~/.bash_profile file with the following command: echo 'export PATH="$PATH:/opt/mssql-tools/bin"' > ~/.bash_profile Optional: Add /opt/mssql-tools/bin/ to your PATH environment variable in a bash shell. To update to the latest version of mssql-tools run the following commands: sudo apt-get update Run the following commands to install SQL Server: sudo apt-get updateĪfter the package installation finishes, run mssql-conf setup and follow the prompts to set the SA password and choose your edition. Register the Microsoft SQL Server Ubuntu repository for SQL Server 2019:įor Ubuntu 16.04: sudo add-apt-repository "$(wget -qO- )"įor Ubuntu 18.04: sudo add-apt-repository "$(wget -qO- )"įor Ubuntu 20.04: sudo add-apt-repository "$(wget -qO- )" Import the public repository GPG keys: wget -qO- | sudo apt-key add. ![]() To configure SQL Server on Ubuntu, run the following commands in a terminal to install the mssql-server package. ![]() If you are using Ubuntu 18.04 or 16.04, change the path below to /ubuntu/18.04/ or /ubuntu/16.04/ instead of /ubuntu/20.04/. The following commands for SQL Server 2019 points to the Ubuntu 20.04 repository. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |