Database Migration after Upgrading (Oracle) Manually
Database migration was introduced in ToolsNet 8.3. When upgrading from a lower version than ToolsNet 8.3 consider the following:
To finalize the migration it is required to run migration scripts after the upgrade using Oracle SQL Developer or similar.
The changes affect the database and change how the application stores traces, units, job results, program parameters and result parameters.
After an upgrade, the migration files are found in the following specified folders. Install the scripts using Oracle SQL Developer in the following order.
Go to C:\ProgramData\Atlas Copco\ToolsNetDatabase\Database scripts\Oracle on the ToolsNet server.
Start Oracle SQL Developer.
Open the folder MigrateToCommonGraph.
Drag the following files in to Oracle SQL Developer.
70_MigrateToCommonGraph.sql.
71_MigrateToCommonGraph_ManageFKandIX.sql.
In Oracle SQL Developer, use the search and replace function to change the database name.
Run the sql. script using the play button.
Install the scripts in the correct order.
Open the folder MigrateToGraphExtraInformation.
Only required if the database contains PF6-series data.
Drag the following files in to Oracle SQL Developer.
76_MigrateToGraphExtraInformation.sql.
72_MigrateToResultExtraInformation.sql .
78_MigrateProgramSetProgramNumber.sql.
In Oracle SQL Developer, use the search and replace function to change the database name.
Run the sql. script using the play button.
Install the scripts in the correct order.
Open the folder MigrateToResultToJobResult.
Drag the following files in to Oracle SQL Developer.
73_MigrateToResultToJobResult.sql.
74_MigrateToResultToJobResult_ManageFKandIX.sql.
In Oracle SQL Developer, use the search and replace function to change the database name.
Run the sql. script using the play button.
