As per the
blog:
“We have made it easier than ever to get started with SQL Server. You’ll find native Linux installations with familiar RPM and APT packages for Red Hat Enterprise Linux and Ubuntu Linux, and packages for SUSE Linux Enterprise Server will be coming soon as well.”
There are many features like operating and programming features in this SQL Server VNext. We will see them later.
Initially those who have installed SQL server on PC or server know it takes a minimum of 45 minutes to install the SQL server and then to configure endpoints (Ports). Here, on the Linux or Ubuntu platform the installation of the rest of the configuration merely takes fewer than 3 minutes. So, here we will see installation on Ubuntu 16.xx
The main advantage of purchasing a SQL server license as compared to others like Oracle is when you purchase SQL Server Standard edition 2016 it comes with all reporting services, tools, and other things and you don’t need to buy that separately . Whereas, with Oracle and any other, first you need to pay for the license for the Database and then if you need any other services like reporting services and other tools you need to pay an additional fee.
Let’s Start,
First login on Azure portal
![]()
After successfully login you will be redirected to Dashboard
![]()
Now we need to create a VM Server where the operating system will be Linux
Click on Virtual Machine->Click on Add above
![]()
Click on Ubuntu Server and select Ubuntu Server 16.10
![]()
Select Ubuntu Server 16.10
![]()
Select Resource manager and then click on Create; after that fill in the details and give a desirable name and enter username and password --we require this username and password to connect to server
![]()
Click Ok and then select the storage structure
![]()
Here I selected the first option as this is just a demo. That much storage is more than sufficient. Then click on Ok; then it will compute all the requirements and just click Ok . When you click Ok it will be redirected to the Dashboard and it will show you that VM server is getting ready; this will take couple of minutes
![]()
So we successfully created VM server here; just validate the details
![]()
Now we will connect IP and install SQL server; for that we will connect that IP through Putty
![]()
Click Ok and we will enter Username and password
![]()
![]()
We are successfully logged in ;now we will just run the commands for the SQL server . First, we will download all the necessary packages and then we will install SQL server and then we will start the service .
To install SQL server on Ubuntu just follow these steps
So SQL Server is successfully installed; it took me just 2 minutes to install SQL server
Now, after installation we will run the configuration script for SA passwords
sudo /opt/mssql/bin/sqlservr-setup
![]()
Type YES and press Enter
Configure SA password
![]()
After configuration of SA password it will ask whether to start SQL service or not type Y and press Enter
![]()
So our Setup has been completed successfully
![]()
We will verify whether the service is running or not
systemctl status mssql-server
![]()
So our service is running.
Now we will configure ports for our SQL server and we will keep the default port which 1433 . So switch back to our Azure Dashboard.
Click on Network Interface ->click on your VM machine
![]()
Then click on Network Security Group
![]()
Click on Inbound Security Rules as
![]()
Configure the port for MSSQL as
![]()
It will create a security rule now let's try to connect SSMS .Enter the IP, Username and password
![]()
Click on Connect
![]()
As you can see from the above output we successfully connected to our SQL server; now let's run some commands. First we will see the version of our SQL Server
![]()
Now let's create a Database as TEST
![]()
Click on the TEST and let's check the mdf and ldf files
![]()
Remember these are now our mount points on Server where these mdf and ldf files are there we will see those on server.
![]()
So, this is our directory
Sudo ls /var/opt/
In that mssql/Data folder
![]()
From the above output you can see our mdf and ldf files.
Earlier, in windows server these MDF and LDF files used to be on the VM drives we used to extend the space if any additional space was required.
Here these are our mount points /var/opt/mssql/data just like any other mount points on Linux/Unix server.
Now we will create a sample table and insert some data
![]()
So it’s working fine just like our earlier versions of SQL server.
Now the question is can we migrate our previous versions of SQL like 2005,2008,2012,2014 to SQL server vnext?
Yes. You can provide your first successful migration of the schema to the destination and then try to move data in chunks .
We will see that I have some tables we will try to migrate on SQL Server vnext
There is an existing database, TEST, in my system we will try to move student table to our SQL server vnext so I generated a script with schema and data
![]()
![]()
Execute the script
![]()
As you can see from the above output we had successfully migrated our table to our SQL Server VNext .
SQL Server VNext Features
![]()
Conclusion
With the rise of SQL server vNext many organizations will try to move their existing databases to SQL server Vnext. As developers or DBAs we will get more hands-on with Linux, like managing the process utilizations and so on
References