From the course: Migrating COBOL Apps

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

The challenges of migrating to a relational database

The challenges of migrating to a relational database - COBOL Tutorial

From the course: Migrating COBOL Apps

Start my 1-month free trial

The challenges of migrating to a relational database

“

- [Instructor] When doing a migration, there is no future in leaving data files in existing ISAM format. This mainly passes on the need for data migration to a follow on migration project unless the application is to be retired. Consequently, the migration project will need to develop a new database schema for the application likely using relational database techniques. In terms of process, the first step then is to take the file definitions from the source code or copybook, and define a mapping to common intermediate format. The data can then be converted into this intermediate form. The definition of the indexes and keys will need to be retained in this form of data. The reformatting of the data will also need to carry out data validation and flag any discrepancies, including checking that any fields which reference other tables are valid. Following this, the database needs to be described in the data definition…

Contents