Pull database from other server

This feature allows you to pull the ESMC database from an existing ESMC VA running in your infrastructure. It is only supported on the ESMC Server, not on the other components (MDM, ERA Proxy 6.x). It is convenient when upgrading your ERA VA to the latest version, or if you want to migrate your ESMC VA.



In case of migration, you need to keep your old ESMC VA accessible in order for the hostname/IP address change policy to apply to all client computers. Otherwise, clients will not be connecting to your new ESMC VA and keep trying to connect to the old one.

Make sure that SSH is enabled on your old ESMC VA.

A database pull can only be performed when moving to a newer version or the same version of ESMC server. During the pull procedure, the database structure is updated but this process will fail when pulling to an older server. Database pull is one of two ways how to upgrade your VA.

To perform a database pull, follow the steps below:

1.Deploy a new ESMC VA, but do not configure it yet.

2.Open the VM's console and on the main screen, press Enter on your keyboard to Enter management mode of your newly deployed ESMC VA.

3.Type eraadmin and press Enter twice to login.


4.Select Pull database from other server using the arrow keys and press Enter.


5.Enter database root password on the remote ESMC VA you want to pull the ESMC database from (your old ESMC VA). If you are only using one password on your old ESMC VA, type it here.

6.Enter connection to remote ESMC VA (SSH) - type user name (root) and your old ESMC VA host name or IP address in the following format: root@IPaddress or root@hostname

7.If you are asked about The authenticity of host, type yes. Otherwise, ignore this step.

8.Type the VM password of your old ESMC VA and press Enter. The message Remote ERA Server database was backed up will be displayed when backup operations are completed.



The amount of time needed for backup and restore operations to complete will vary depending on database size.

9.Type the VM password of your old ESMC VA again. You might be asked to enter the password multiple times during copying, depending on time takes to copy the database.

10. Wait until the database is restored.


11. If you are performing an upgrade: After a successful ESMC database pull, shutdown old ESMC VA to decommission it.



We recommend that you keep your old ESMC VA long enough before you verify that the new instance is functioning properly.

We strongly recommend that you do not uninstall the old ESMC VA Server using an uninstallation script. This will dissociate (remove) all licenses from the new ESMC VA Server database as well. To prevent this behavior, delete the old ESMC VA Server database (DROP DATABASE) before the uninstallation.

12. Configure your new appliance:

Upgrade - configure your new VA exactly the same as your previous ESMC VA.

Migration - change configuration to suit a new domain (configure or rejoin domain) or network properties, for example, if you have moved your ESMC VA to a different network.



Make sure all data is preserved, all clients are connecting to your new server and your ESMC VA behaves the same way as the previous one.