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 following the database vendor's instructions:

Upgrade SQL Server https://msdn.microsoft.com/en-us/library/bb677622.aspx

Upgrade MySQL Server (to version 5.6) http://dev.mysql.com/doc/refman/5.6/en/upgrading.html

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