Step 4: Migrating existing data

After you upgrade to BMC ProactiveNet Performance Management Reporting 9.5 or 9.5.01 from version 8.6.x, 9.0, 9.0.20, or 9.0.22, to be able to use the old data to generate reports, you must migrate the old data.

To migrate existing data

Perform the following steps to migrate existing data.

1. Back up the source database.
2. Copy Oracle folder from the following location from the Report Engine to database server.
   BMC_PROACTIVENET_REPORTENGINE_HOME\ReportEngine\schema\developer\ 
3. Ensure the ORACLE_SID variable is set to the Report Engine Oracle Database name.
4. Edit either of the following files as per your operating system and change the values of the ORACLE_HOME and ORACLE_SID variables.
   • (Windows) REDatabaseCli.bat 
   • (Solaris and Linux)REDatabaseCli.sh 
5. Stop Report Engine service. If you are using Multiple Report Engines, stop all Report Engine services before starting the Migration.

6. Run the following command: REDatabaseCli <RE DB USerName> <RE DB USerPassword> migrate_data_to_9.5 
   

   Example

    REDatabaseCli re re  migrate_data_to_9.5

   
   After you execute the command, the following messages are displayed on the screen.
   

   Data migration for impact data successfully completed.

   Data migration for event data successfully completed.

   Data migration for performance data successfully completed.

   Data migration for report engine 9.5 completed successfully.
7. If you are using Multiple Report Engines, repeat the previous step for remaining report engines. 
8. Restart the Report Engine service.