The database and data conversion phase begins very early in the conversion project. The new database designs, with their new naming conventions, become the basis for the conversion and generation of the related applications.
The application software conversion takes place simultaneously with the database and data conversion. It is recommended that the database administration teams be involved in the Database and Data Conversion thread, and that the application teams be involved in the Application Conversion thread.
The following high-level tasks take place during the database and data conversion phase:
- Provide a Database Definition form for each IDMS schema listed in the Environment Form
- Provide reports regarding occurs clauses, redefines clauses, group levels and potential date fields
- Provide guidance in correctly and completely filling out the Database Definition form(s)
- Import the schema/database definition report(s)
- Generate the initial SQL Imager load summary reports for the schema(s)
- Review the complexity reports for the schema(s)
- Review log messages for any errors during the import and initial parse phases
- Load the table naming rules defined in the submitted Database Definition form(s)
- Load the column naming rules as defined in the submitted Database Definition form(s)
 
Following are some of the database-related reports that are delivered as part of the Data Conversion phase:
- Data Cleansing Report
- Date Conversion Detail
- Element Rename Detail
- Extract File Cross-Reference
- Extract Program Matrix
- Index Columns
- Key Columns
- Key Inheritance Existing Fields
- Key Inheritance Inserted Fields
- Key Mapping Summary
- Key Rename Summary
- Load Errors
- Load Summary
- Record Scoring
- Record Table Comparison All
- Record/Table View by Schema
- Date Finder Report
The resulting relational database definitions are packaged and delivered, ready for installation in the new target environment. The data extract programs are packaged and delivered, ready for compilation and execution in the former database processing environment.
|
