Database Server Upgrade

Follow the instructions below to upgrade an existing Microsoft SQL Server instance to a newer version for use with ESMC Server database:

1.Stop all running ESMC Server or ERA Proxy services connecting to the database server that you will be upgrading. Additionally, stop any other applications that might be connecting to your Microsoft SQL Server instance.

2.Back up all relevant databases safely before proceeding.

3.Perform the database server upgrade:

Upgrade SQL Server:

Follow the Knowledgebase article for upgrading MS SQL Express 2008 database to the latest version. Alternatively, following the database vendor's instructions:

Upgrade MySQL Server:

Upgrade from MySQL 5.5 to version 5.6

Upgrade from MySQL 5.6 to version 5.7

Upgrade from MySQL 5.7 to version 8

4.Start ESMC Server service and check trace logs to verify the database connection is working correctly.