Issue
Customer would like a procedure for migrating their PME databases to a new server.
Product Line
Power Monitoring Expert 8.2
Environment
Database Migration
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 backup the registry before making any changes.*
On the old database server
On the new database server
On the Application Server
Customer would like a procedure for migrating their PME databases to a new server.
Product Line
Power Monitoring Expert 8.2
Environment
Database Migration
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 backup the registry before making any changes.*
On the old database server
- Backup the 4 PME databases: ApplicationModules, ION_Data, ION_Network, ION_SystemLog
- Export the report subscriptions:
- In SQL Management Studio click View -> Object Explorer Details.
- Select the Jobs folder under SQL Server Agent. The contents should appear in the Object Explorer.
- Select all the rows with Globally Unique Identifiers for names, such as 7e58be83-8b5b-4423-955c-7954fa69c2c7.
- Right click and choose Script Job As Create to File.
- Copy both the database backups and the exported SQL agent jobs script to the new database server.
On the new database server
- Restore the databases
- Import the report subscriptions by running the script generated in Step 2.
On the Application Server
- Stop the following services
- ApplicationModules Alarm ServiceHost
- ApplicationModules CoreServicesHost
- ApplicationModules DataServicesHost
- ApplicationModules ProviderEngineHost
- ION Alert Monitor
- ION Component Identifier Service
- ION Connection Management Service
- ION Diagnostics and Usage Service
- ION Event Watcher Service
- ION Log Inserter Service
- ION Managed Circuit Service
- ION Network Router Service
- ION OPC Data Access Server
- ION PQDIF Exporter Service
- ION Query Service
- ION Real Time Data Service
- ION Report Subscription Service
- ION Site Service
- ION Software Alarm Service
- ION Software Modbus Gateway Service
- ION Virtual Processor Service
- ION Virtual Processor Service – NVIP.PQADVISOR
- ION Virtual Processor Service –NVIP.Data_Center*
- ION Virtual Processor Service –NVIP.Data_Center_Alarming*
- ION XML Subscription Service
- ION XML Subscription Store Service
- World Wide Web Publishing Service
* These services are only present in the Data Center edition of PME.
- Delete logserver and query server files located here:
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>
C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\config\cfg\logsrv\QUERYSERVER.<MACHINENAME>
- Update the InstallInfo.xml
- Open the InstallInfo.xml file using a text editor. InstallInfo.xml is located here: C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\Uninst_PowerMonitoringExpert.
- 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" becomes globalEEMDBName="NEWSERVER"
globalEEMDBName="OLDSERVER" becomes globalEEMDBName="NEWSERVER"
globalEEMDbServer="OLDSERVER\ION" becomes globalEEMDbServer="NEWSERVER\ION"
- Update the Registry
- Open regedit and navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Schneider Electric\Power Monitoring Expert\8.2\Databases.
- Update the Data for the following keys to reflect the new servername: IONServer, NOMServer, SYSLOGServer
For example, OLDSERVER\ION becomes NEWSERVER\ION
- Run a Reconfigure
- Open Windows Programs and Features.
- Right-click on Power Monitoring Expert.
- Select Change.
- Select the Reconfigure option.
- When the database software page loads it should be indicating it will run against the new SQL Server.
發佈於: 施耐德電機Taiwan
