Database Migration after Upgrading (Microsoft SQL) 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 Microsoft SQL Server Management Studio or similar.
The changes affect the database and change how the application stores traces, units, job results, program parameters and result parameters.
Migration using script
After an upgrade, the migration files are found in the following specified folders. Install the scripts in the following order, using Microsoft SQL Server Management Studio.
Go to C:\ProgramData\Atlas Copco\ToolsNetDatabase\Database scripts\Sql Server on the ToolsNet server.
Start Microsoft SQL Server Management Studio.
Open the MigrateToCommonGraph folder.
Drag the following files into Microsoft SQL Server Management Studio.
70_MigrateToCommonGraph.sql.
71_MigrateToCommonGraph_ManageFKandIX.sql.
In Microsoft SQL Server Management Studio, use the search and replace function to change the database name.
Execute the sql. script.
Install the scripts in the correct order.
Open the MigrateToGraphExtraInformation folder.
Only required if the database contains PF6-series data.
Drag the following files into Microsoft SQL Server Management Studio.
76_MigrateToGraphExtraInformation.sql.
72_MigrateToResultExtraInformation.sql .
78_MigrateProgramSetProgramNumber.sql.
In Microsoft SQL Server Management Studio, use the search and replace function to change the database name.
Execute the sql. script.
Install the scripts in the correct order.
Open the MigrateToResultToJobResult folder.
Drag the following files into Microsoft SQL Server Management Studio.
73_MigrateToResultToJobResult.sql.
74_MigrateToResultToJobResult_ManageFKandIX.sql.
In Microsoft SQL Server Management Studio, use the search and replace function to change the database name.
Execute the sql. script.
