Converting a database using SCT
Once you have completed the assessments and decided on a target database, you can use SCT to assist in converting the database objects and code. SCT carries out the following tasks:
- SCT installs an extension pack that contains common functions that can be used in converted database code. This extension pack is supplied within the SCT program.
- SCT checks all DDL statements in the source database and attempts to recreate those in the language of the target. This includes tables, views, indexes, and more.
- SCT attempts to convert the database's code into the target database's code.
- For those who cannot automatically convert either using the native code of the target database or via the added extension pack functions, it provides a report that shows where the issues with the conversion are and what action you need to take to resolve them.
Figure 10.2 showed some example output of an assessment report for a SQL Server source...