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. 

Before performing and upgrade you MUST backup your databases. 

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).

Steps to perform an in-place upgrade of SQL 2012 to SQL 2019.

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

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

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

4. Choose Upgrade

5. Choose the SQL Instance that WIMS is using.  Should default to OPSSQL:

7. 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 9/17/2020 2:40 PM.
Last Modified by Scott Dorner.
Article has been viewed 69 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article