List Headline Image
Updated by Mad Rever on Mar 07, 2016
Headline for IMS to SQL migration principles
 REPORT
Mad Rever Mad Rever
Owner
5 items   1 followers   0 votes   0 views

IMS to SQL migration principles

Listly by Mad Rever

The IMS to SQL migration is broken down into two phases : creation of the new database & migration of the data and then transformation of the application programs

1

IMS to SQL migration : Principles (1/4)

IMS to SQL migration : Principles (1/4)

Goals of an IMS to SQL migration, transforming programs for them to use the new database, without needing to modify the functionalities.

2

IMS to SQL migration : Part 2 of 4

IMS to SQL migration : Part 2 of 4

IMS to SQL migration : how data can be migrated from the legacy database to the new one. Reverse engineering, conception, ...

3

IMS to SQL migration : Part 3 of 4

IMS to SQL migration : Part 3 of 4

Data migration consists in reading the data of the legacy base in order to write them in the new base, while guaranteeing that they all have been copied.

4

Data migration consists in reading the data of the legacy base in order to write them in the new base :

  • data extraction from the legacy database in order to produce one file per IMS segment
  • data transformation read in order to format them for the new database
  • data loading in the new database
5

MIGRATION VALIDATION

Three types of validation are available :

  • Counters
  • Checksum
  • XML comparison REVER has developed different plugins allowing the automation of the implementation of all 3 validation techniques.