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 supported only 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.

validation-status-icon-warning IMPORTANT

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 not the recommended way of upgrading. It is recommended to upgrade via Components Upgrade task and after successful upgrade pull the database to another server if needed.

To perform database pull, follow the steps below:

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

2.Open VM's console and while in 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.

pull_db_login

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

pull_db

5.Enter database root password on the remote ESMC VA you want to pull ESMC database from (your old ESMC VA). If you are using only 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.Type yes  if you are asked about The authenticity of host, 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 finished.

details_hoverNOTE

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 it takes to copy the database.

10. Wait until the database is restored.

pull_db_interactive

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.

12. Configure your new appliance:

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

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

details_hoverNOTE

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