Update SQL Server

The Center for Technology & Training (CTT) is ending support of SQL Server 2016 in December, 2026. After that, the CTT will support SQL Server versions: 2017, 2019, 2022, and 2025. For help locating your SQL Server version, review the Locate SQL Server Version documentation.

Agencies running MERL databases using purchased versions of SQL Server (Enterprise, Business Intelligence, Standard, etc.) should contact their office technical support for SQL Server update assistance.

See Understand the Need for SQL Server for more information on why the SQL Server application is a necessity.

Update SQL Server Express to a Newer Version

Write permission on the server is required for networked server installations.

1. Install the newest instance possible.

   SQL Express installers can be requested by contacting the CTT at merl@mtu.edu.

2. Create a database backup. See Back Up, Move, & Restore Database for instructions.
3. Restore the backup to the new server. See Back Up, Move, & Restore Database for instructions.

   Please Note: While it is possible to do steps 3 and 4 using SQL Server tools, it is important to use the functionality provided by MERL to ensure the process goes smoothly and successfully.

4. Log into MERL and connect to the new Server/Database via the Options->Change Server/Database button.
5. Confirm that the connection is successful
6. Connect all other users to the new Server/Database.