Technical FAQs

Ask a Question

How to determine how long it will take to upgrade databases during a PME 8.1 or 8.2 upgrade?

Issue
User is looking estimated amount of time to complete the database upgrade portion of upgrading an StruxureWare Power Monitoring or Power Monitoring Expert system

Product Line
Power Monitoring Expert 8.1
Power Monitoring Expert 8.2

Environment
Power Monitoring Expert 8.1 and 8.2 software upgrade

Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.* 

Run the attached script on the ION_Data database to get an estimate on how long the database upgrade will take. This is only the time it will take to complete the database upgrade step and not how long the overall upgrade process will take. 

NOTE: The attached script only works on Struxureware Power Monitoring 7.0 and higher databases.
Was this helpful?
What can we do to improve the information ?