Convert Database Schema

 

The Data Transfer Wizard (DTW) enables databases from version 5.5 or earlier to run correctly with the latest version of ATS Inspect.

How Many Times Must DTW be Run?

       Databases at version 5.4 or earlier: DTW must be run twice. Once after the 5.5 upgrade and then again when the database that DTW has created has been updated to the latest version.

       Databases at version 5.5: DTW only needs to be run once when the database has been updated to the latest version.

Running Database Transfer Wizard

To complete the database conversion the data in the original database must be copied to a new database. Carry out the following steps:

1.     Update the source database

o       For version 5.4 or earlier: update to 5.5.

o       For version 5.5 update to the latest version.

2.     Create a new destination database with the same schema version as the source database.

3.     Create the required custom tables in the new database so that data can be copied into them.

4.     Open the Data Transfer Wizard.

5.     Select the database type for the source database.

6.     Enter the Host and Database details for the source database.

7.     Enable Update statistics (optional). If statistics are obsolete the execution plan may not be optimal and so may slow down the transfer.

8.     Click Connect.

The Database Version/Schema details are filled in.

9.     Change the schema if required.

10.  Repeat the previous steps for the destination database.

11.  Modify the Transfer Log location (optional) which will contain details of how the transfer went.

12.  Enable Perform data error check before transfer (optional). This will check whether the data will be transferred correctly.

13.  Click Next.

The Data Transfer Wizard compares all of the tables and displays a list highlighting the differences between the two databases.

14.  View the details of a table by expanding it.

15.  Click Next.

The data will be copied from the source database to the destination database.

If there is an issue while copying the data the transfer will be stopped and a message will appear like the one shown below.

16.  Modify the source database to resolve the issue.

17.  Re-run the Database Transfer Wizard.

18.  When the data is successfully copied click Next.

The database transfer is completed.

19.  Click Finish.

If the database was updated to version 5.5 then the process must be repeated to update it to the latest version.