Home : SQL 2012 to SQL 2019
Q14597 - HOWTO: SQL 2012 to SQL 2019

As of Sept 17th, 2020, WIMS installs SQL 2012 Express (unless DB_Support is added to license).  As SQL 2012 support ends in 2021, users may want to update to SQL 2019. 

This will NOT violate your WIMS license agreement with Hach. 

Step 1: Backup your WIMS databases including OPSROOT.

Step 2: Verify your OS is compatible with SQL 2019.

SQL 2019 requires Windows 10 or Server 2016 or later (please see https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-ver15 for more info).

Step 3: Verify you are running SQL 2012 Service Pack 2 or later. 

In order to update to SQL 2019 you must be running SQL 2012 SP2 or later. 

Use SQL Management studio or SELECT @@version to determine version:

To update to SP2:  Go to https://www.microsoft.com/en-us/download/details.aspx?id=43340 to install SQL 2012 Service Pack 2.

 

Step 4: Perform the in-place upgrade of SQL 2012 to SQL 2019.

a. Go to microsoft.com/en-us/sql-server/sql-server-downloads

b. Run the downloaded program (SQL2019-SSEI-Expr.exe).  Choose Custom Install:

c. Set the folder to DBMS.  (Note: Not sure this is required, this appears to be where the installation media gets placed???)

d. Choose Upgrade

e. Click Next thru the Upgrade steps until you reach the Select Instance page.  Choose the SQL Instance that WIMS is using.  Should default to OPSSQL:

f. Feature Rules will be checked.  Note: you may get a warning on Database Compatibility which can be ignored.  Click Next and the OPSSQL SQL 2012 instance will be updated to 2019.

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 9/17/2020 2:40 PM.
Last Modified on 3/26/2021 5:10 PM.
Last Modified by Scott Dorner.
Article has been viewed 2394 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article