[KB5662] How do I upgrade or migrate my ESET Remote administrator database?

Upgrade your exsiting SQL database server to a newer version for use with ESET Remote Administrator
Migrate your database to a new physical server

This article focuses primarily on two SQL database types supported by ESET Remote Administrator:

Complete the steps below to migrate your database, complete all steps in part I before you proceed to part II.

Stop all running ESET Remote Administrator Server (ERA Server) or Proxy (ERA Proxy) instances that connect to the database you plan to upgrade.
- Follow the steps from this article but select Stop rather than Start in the Services window.
Ensure that the database you plan to upgrade has been properly backed up.
Follow the instructions from the appropriate article below for your database type:
- Microsoft SQL Server: https://msdn.microsoft.com/en-us/library/bb677622.aspx
- MySQL Server: http://dev.mysql.com/doc/refman/5.6/en/upgrading.html

Click your database type below to view instructions:

Prerequisites

The source and target SQL Server instances must be installed. They may be hosted on different machines.
The target SQL Server instance must have at least the same version as the source instance. Downgrading is not supported
SQL Server Management Studio should be installed on both machines

Procedure

Stop the ERA Server or ERA Proxy service.
- Follow the steps from this article but select Stop rather than Start in the Services window.
Log in to the source SQL Server instance using SQL Server Management Studio.
Create a full database backup of the database that will be migrated. To do so, follow the steps below:
1. Right-click the database in SQL Server manager and select Tasks → Back Up.
2. Provide a new, unique backup set name in the Name field.

Last Updated: Aug 8, 2023