Learn more about SQL Server tools

mssqltips logo
giveaway
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Upgrading SQL Server vNext on Red Hat Linux to latest available update


By:   |   Read Comments (3)   |   Related Tips: More > SQL Server on Linux

Problem

Microsoft released an update for SQL Server on Linux from CTP 1 to CTP1.1. The upgrade will change the version from 14.0.1.246 to 14.0.100.187. I described the installation steps of SQL Server vNext CTP 1 for Linux in my last tip and in this tip I will let you know how to upgrade to CTP 1.1 for SQL Server vNext on Linux.

Solution

Microsoft released its first public preview for SQL Server on Linux on the 16th of November 2016. Recently they have released an update of SQL Server vNext and which is now CTP1.1. You can read the latest release notes of SQL Server vNext on Linux to get more details. The SQL Server engine version for this release is 14.0.100.187 where it was previously 14.0.1.246. You can also get a list of all the known issues of this version of SQL Server in this link. There are also a few new features introduced in this version.

Upgrading SQL Server vNext on Red Hat Linux

Before going ahead, you need to have a Linux box running with SQL Server vNext CTP 1 which we will upgrade to CTP 1.1. I followed the step by step method of Microsoft's online documentation to understand this upgrade. Now let's start the upgrade from SQL Server vNext CTP 1 to CTP 1.1.

Step 1

First, I would recommend running full backups for of all your user and system databases to keep a copy in case anything goes wrong with the upgrade and we need to restore the databases. As SQL Server vNext is in CTP phase, I assume you do not have anything critical running on this version, so you can skip this step if you want.

Step 2

Now connect to the Linux server. I connected to the Linux server using the PuTTY application as shown in the below picture.

connect to Linux Server

Step 3

Now we will check the existing version of SQL Server vNext running on the Linux server. Connect using the sqlcmd utility and execute the below command to get the version details.

#connect to SQL Server. Enter the sa password once you get the password prompt.
sqlcmd -S192.168.209.128 -Usa

#check installed version of SQL Server once connected to SQL Server.
SELECT @@VERSION
GO

We can see the installed version below which is SQL Server vNext CTP1 (14.0.1.246).

check version

Type exit to exit the sqlcmd prompt.

exit

Step 4

Now we will check the available updates of SQL Server for the upgrade. Although this is not necessary to perform, this will give you a better picture and help you understand the process of the upgrade. We will use the yum command line to check the available updates. The yum command allows users and system administrators to easily install, update, remove or search software packages on a system. Run the below command to check for updates.

#check available updates for SQL Server
yum check-update mssql-server

We can see one update is available for SQL Server in the below picture which we will use to upgrade SQL Server with the help of this package. The version of this package shows 14.0.100.187-1.

check updates of sql server

We can also check details by running the below command. This command will give detailed information about the target package.

#check available updates for SQL Server
yum info mssql-server

There are two package details as shown below. The first shows what is installed which is SQL Server vNext CTP 1 and the second is for the available CTP 1.1 version. We will run the same command post upgrade to compare the before and after.

yum info mssql-server

Step 5

The SQL Server upgrade was pending one update from the above step and now we will upgrade the SQL Server in this step. We will use yum command to apply the update. These commands will download the newest package and replace the binaries located under /opt/mssql/. The user generated databases and system databases will not be affected by this operation. It's also a good idea to create backups of your databases just in case. Run the below command to start the update.

#Upgrade SQL Server.
sudo yum update mssql-server

Once we will execute this command it will ask for the sudo password. Execution will start and it will ask you to type "y" to proceed. You can also see the package name along with its version details as shown below.

upgrade

Once you enter "y" to proceed, the package download process will start as shown below.

upgrade

Once package is downloaded, the upgrade process will start and show a progress bar.

upgrade

Once the upgrade successfully completes, you will get the below screen with the status showing as complete.

upgrade

Step 6

Now the SQL Server has been upgraded from build 14.0.1.246 (SQL Server VNext CTP 1) to 14.0.100.187 (SQL Server vNext CTP 1.1). We can verify it by executing the same command which we executed in Step 3. We can see below the SQL Server version  is now 14.0.100.187 (CTP1.1).

check SQL Server version

We can execute a general query to validate the SQL Server accessibility as well. I just queried the name of all databases was hosted earlier on this instance and we can see the command executed successfully.

check sql server accessbility

Step 7

As we have updated SQL Server with the latest available package, now we can run the yum info command to check the package details of SQL Server to compare it what was in Step 4. We can see below there is only one package showing the latest version. Earlier there were two packages Step 4, one was showing the installed package and the other was showing what was available.

yum info mssql-server
Next Steps


Last Update:






About the author
MSSQLTips author Manvendra Singh Manvendra Singh has over 5 years of experience with SQL Server and has focused on Database Mirroring, Replication, Log Shipping, etc.

View all my tips
Related Resources





More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Wednesday, April 19, 2017 - 9:24:19 AM - Manvendra Back To Top

 And it is there now. Follow the link to update sql server on ubuntu.

 

https://www.mssqltips.com/sqlservertip/4647/upgrading-sql-server-running-on-ubuntu-to-latest-update/

 


Tuesday, April 04, 2017 - 3:46:38 AM - Manvendra Back To Top

 

Thx Oleg,

 

"Updating mssql on ubuntu" will be publishing in coming weeks. Stay tuned. :)


Monday, April 03, 2017 - 3:41:49 AM - Oleg Back To Top

Thank you for the useful article.

What about: how to update MSSQLServer on Ubuntu? 

 


Learn more about SQL Server tools