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:
   2. 

   3. 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

   Backup all of the "ServiceMetaData" registry keys

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

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> 

12. Update the InstallInfo.xml

1. 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.
      1. For example:

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

   3. If there has ben a cumulative update installed on the server then the InstallInfo.xml for that update will also need to be edited in the same way. InstallInfo.xml can be found in the directory containing that update.
      1. For example Cumulative Update 1 for PME 2022 would be located in the following directory:

         C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\Uninst_PME 2022 Cumulative Update 1

On the PME application server

14. Run a Reconfigure

15. If any Cumulative Updates have been installed rerun those as well

Udgivet til: Schneider Electric Danmark