How to change the SQL instance connected to PME

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 Studio (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

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

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

Backup all of the "ServiceMetaData" registry keys

1. 9. Update the registry key in the “Dependencies” field to match the new SQL Service name.

if it changed.

Example of the default MS SQL Service name:

1. 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 the 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 set up the PME SQL users in the new SQL instance. Please follow instructions in the script

On the PME application server

1. 16. Run a Reconfigure

게시 대상: 슈나이더 일렉트릭 Korea