The arrival of Microsoft's SQL Server has made many users impatient and want to try the new Microsoft for Ubuntu but do not forget that it is still in development and not for use in production equipment.
In any case there is the possibility of installing SQL Server in our Ubuntu without having to do strange things, we only need to have Ubuntu on our computer and an Internet connection to install Microsoft's SQL Server.
SQL Server installation
Microsoft servers are still proprietary, so in this case to install SQL Server we have first to have credentials to download the files, so we open a terminal in Ubuntu and do the following:
sudo su
To enter with team administrator permissions.
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
With this we request a credential to be able to download files from the Microsoft repository. Now we write the following:
curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list & /etc/apt/sources.list.d/mssql-server.list
And with this we will add the Microsoft repository to our sources.list so Ubuntu will always update this software.
exit sudo apt-get update sudo apt-get install -y mssql-server
SQL Server Configuration
This will begin the SQL Server installation. But now we have to configure it. For this we will use a script that Microsoft has created for this purpose. So we write the following:
sudo /opt/mssql/bin/sqlservr-setup
Once we're done, we just have to run the service so that SQL Server starts the Ubuntu session, although whenever we start Ubuntu it will start automatically, so we write the following to start the server:
systemctl status mssql-server
Conclusion
As you can see, the installation process is simple, a simple process that we can all use, but remember that SQL Server is still under developmentIt is a preview version and can cause problems, so we recommend that it be done in a virtual machine and if you can with a few services, better, as it can cause critical failures. Do not forget it.