Migrated Database - same IP address

The objective of this procedure is to install an entirely new instance of ERA Server and keep your existing ERA database, including existing client computers. The new ERA Server will have the same IP address as the old ERA Server, and the database of the old ERA server will be imported to the new server machine prior to installation.

validation-status-icon-warning IMPORTANT: Migrating databases is only supported between identical database types (from MySQL to MySQL or from MSSQL to MSSQL).

validation-status-icon-warning IMPORTANT: When migrating a database, you must migrate between instances of the same ESET Remote Administrator version. For example when you have ERA, you can only migrate to ERA version See our Knowledgebase article for instructions to determine the versions of your ERA components. After completing database migration, you can perform an upgrade, if necessary, to get the latest version of ESET Remote Administrator.


 On your current (old) ERA Server:

1.Export a server certificate from current ERA Server and save onto your external storage.

oExport all Certification Authority Certificates from your ERA Server and save each CA certificate as a .der file.

oExport Server Certificate from your ERA Server to a .pfx file. Exported .pfx will have private key included as well.

2.Stop the ERA Server service.

3.Export/Backup the ERA Database.

4.Turn off the current ERA Server machine (optional).

validation-status-icon-warning IMPORTANT: Do not uninstall/decomission your old ERA Server yet.


On your new ERA Server:

validation-status-icon-warning IMPORTANT: Make sure the network configuration on your new ERA Server (IP address, FQDN, Computer name, DNS SRV record) matches that of your old ERA Server.

1.Install/Launch a supported ERA database.

2.Import/Restore the ERA database from your old ERA Server.

3.Install ERA Server using the All-in-one package installer (Windows) or choose another installation method (Windows manual installation, Linux or Virtual Appliance). Specify your database connection settings during installation of ERA Server.

4.Connect to ERA Web Console.

5.Import all CAs exported from your old ERA Server. To do so, follow the instructions for importing a public key.

6.Restart the ERA Server service, see our Knowledgebase article for details.

Client computers should now connect to your new ERA Server using their original ERA Agent certificate, which is being authenticated by the imported CA from the old ERA Server. If clients are not connecting, see Problems after upgrade/migration of ERA Server.


Old ERA Server uninstallation:

Once you have everything running correctly on your new ERA Server, carefully decommission your old ERA Server using our step-by-step instructions.