Issue
The customer would like a procedure for migrating their PME databases to a new server without requiring the software to be uninstalled.

Product Line
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023
Power Monitoring Expert 2024

Environment
SQL Server Management Studios (SSMS)

RegEdit

Resolution

*Warning: Take backups of any files prior to modifying them. Ensure the backups are in a location that will not be overwritten (i.e. the Desktop).
*Warning: This article contains information about editing the registry. Improper changes to the registry can permanently damage the operating system. Always back up the registry before making any changes.*

On the old database server

1. Backup the 4 PME databases from the source SQL instance:
   1. (ApplicationModules, ION_Data, ION_Network, ION_SystemLog)
2. Migrate the database backups to the new database server.

On the PME application server

3. Stop all of the services associated with the Power Monitoring Expert software
   1. For more information about how to stop all PME associated services, please see article # FA366487

On the old database server

4. Detach the 4 databases from the source SQL instance

On the PME application server

5. Open the Registry Editor “regedit”
6. Navigate to the following directory

   HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Schneider Electric\Power Monitoring Expert\[Version # (i.e. 11.0)]\Databases

7. Back up all of the "Databases" registry keys
   1. Right-click the "Databases" registry keys
   2. Export the selected keys to a file folder that backups have been designated for
8. Update the registry key in the “Data” field to match the new database server name and instance name
   1. Do this for all 4 databases (Use the following example image as a guide:)

Tip: If both the server name and the instance name have changed be sure to update the registry key accordingly:

i.e. SERVER1\ION => SERVER2\ION2

Alternatively, if only  the instance name has changed, update the registry accordingly:

i.e. SERVER1\ION => SERVER1\ION2

9. Still within the RegEdit application, navigate to the following directory:

   HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Schneider Electric\Power Monitoring Expert\11.0\ServiceMetadata

10. 9. Backup all of the "ServiceMetaData" registry keys
    10. Update the registry key in the “Dependencies” field to match the new database server name and instance name
        1. The following registry keys need to be updated:
           1. AlarmServiceHost
           2. CoreServicesHost
           3. CoreServicesHostx64
           4. DataServicesHost
           5. DataServicesHostx64
           6. IONDiagnosticAndUsage
           7. PMALARM
           8. PMLNetman
           9. ProviderEngineHost
           10. ProviderEngineHostx64

    On the new database server

    12. Restore the 4 database backups to the destination SQL instance

    On the PME application server

    13. Delete logserver and query server files located in the following directory:

        C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\config\cfg\logsrv\LOGINSERTER.<MACHINENAME>
        C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\config\cfg\logsrv\QUERYSERVER.<MACHINENAME> 

    14. Update the InstallInfo.xml
        1. Open the InstallInfo.xml file using a text editor. The InstallInfo.xml is located in the following directory:

           C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\Uninst_PowerMonitoringExpert

        2. Look for instances of the old database server name and change it to the new name. There are two of them, globalEEMDBName and globalEEMDbServer.

    For example,

    globalEEMDBName="OLDSERVER" => globalEEMDBName="NEWSERVER"
    globalEEMDbServer="OLDSERVER\ION" => globalEEMDbServer="NEWSERVER\ION" 

    On the new database server

    15. Run FIX_PME_Users.sql script to properly setup the PME SQL users in the new SQL instance. Please follow instructions in the script

    On the PME application server

    16. Run a Reconfigure

Released for: Schneider Electric Philippines