Migrating a SQL Server Agent or Oracle Agent
Upgrade the Oracle and SQL Server cartridges to 18.104.22.168 or higher
The upgrade wizard will automatically disable Infobright PI for existing SQL Server and Oracle database agents.
- Disable the Infobright PI extension for SQL Server agents
- Disable the Infobright PI extension for Oracle agents
- Pause the PI Engine for SSAS agents
- Disable Infobright PI for SQL PI agents
Delete SQL PI Agents
Delete the PI Repository Manager Agent (SPIRepository-xxxxx_xxxxx) and PI Domain Manager Agents (DBSS-SPIRepository-xxxx-xxx, DBO-SPIRepository-xxxx-xxx) that are connecting to the Infobright PI repository through Agent Status dashboard.
Migrate PI data (optional)
- Initialize the SQL PI schema in the SQL Server-based PI Repository
- Select one of the existing agents that was connected to Infobright PI repository, and enable the PI extension
- After the SQL PI extension has been enabled successfully on the agent from Step A, disable the PI extension immediately
- Deactivate the SQL PI agents (SPIRepository-xxxxx_xxxxx, DBSS-SPIRepository-xxxx-xxx, DBO-SPIRepository-xxxx-xxx) that are connecting to the SQL Server-based PI repository
- Follow the SQL Server-based PI Repository Migration Tool User Guide to complete the SQL PI data migration
- Activate SQL PI agents (SPIRepository-xxxxx_xxxxx, DBSS-SPIRepository-xxxx-xxx, DBO-SPIRepository-xxxx-xxx) that are connecting to the SQL Server-based PI repository
Note: this step can be skipped if you don't want to keep the historical data in the Infobright PI repository.
Re-enable PI with SQL Server-based PI Repository
- Go Databases dashboard and Select one of the existing agents that was connected to Infobright PI repository
- Go to Databases | Administration | SQL Performance Investigation
- Select agents and click the "Enable" button
- The SQL Server-based PI repository needs to be attached first if the DB Agent Manager has not yet been attached to the PI repository
- If PI data is migrated, please select the SQL Server-based PI repository created in step "Migrate PI data"
- Navigate to Administration | Tooling | Script Console, Click the Scripts tab in the bottom panel, Click the Add button, clear the Script Text panel contents and paste in the contents from unpausesqlpi.groovy and then click the Run button
- Then remove the contents from the field and replace the Script Text contents with the code from check_for_any_paused_SQLPI_revised_V2.groovy. There should be no database agents listed in the output. If any agents are still listed as paused, please rerun steps #4 and #5.
The following video details the process to Delete the SPI agents and Re-enabled PI with SQL Server-based PI Repository