How to perform a manual EM database update
Table of Contents
Applies for EMv6 & EMv7
How to perform a manual EM database upgrade
The Setup EmMigrate.exe file is required to perform a manual database backup of an EM instance. During a normal update of the EM sever via Setup, a database update is performed automatically when the installation has been completed. This works only if one of the first 3 digits of the version has changed. If only the fourth digit is changed, no automatic update is performed; rather, Setup must be unpacked manually and the data must be copied into the target directory. Use the following command to unpack Setup:
msiexec /a "C:\%Folder%\Matrix42 Enterprise Manager.msi" /qb TARGETDIR="C:\%Folder%"
After you have unpacked Setup, 2 folders and the MSI file can be found in the directory:
The folder "Matrix42" contains all installation files required for the Enterprise Manager.
Please note the following when copying/replacing these files in the installation directory:
-
EmServerandEmImportservice must be stopped. - Copy the files and then restart the services.
The following folders and files should be backed up if all files shall be copied into the installation directory:
- Folders:
AutoUpdate,CertificatesundCustomizing - Files:
EmImport.exe.configandEmServer.exe.config
The folder "Mx42EM-(DateTime)" contains the file EmMigrate.exe, which is required to perform a manual database update. This file must be used to move or install a backup from an older EM version.
It is important to execute the EmMigrate.exe file with the following parameters to run it successfully:
„Start EmMigrate.exe with /v:<Active EmVersion> /s:<DBServername> /d:<DBName> /u:<DBAccount> /p:<DBPassword>“
e.g.: „C:\Windows\Temp\EmMigrate.exe“ /v:6.0.0.0 /s:S01 /d:MX42EM /u:sa /p:Matrix42
After this step, a window will open and the database will be updated automatically.
