JD Edwards database migration involves transfer of table definitions and data from than 3,000 tables to another database platform.

• Migrating JD Edwards from IBM DB2
  • JD Edwards DB2 database contains tables in the following schemas: PRODDTA (business data), HISTDTA (history data), PRODCTL (control tables), SY9/OL9/DD9/SVM0-xx (System Tables), PD9/MS9/PY9/DV9 (Central Objects)
  • Data Types - CHAR, CHAR FOR BIT DATA, VARCHAR, INTEGER, DECIMAL, TIMESTAMP, GRAPHIC, VARGRAPHIC, BLOB, DBCLOB
  • Default values defined on many columns
  • Primary keys are widely used
  • No foreign keys
  • No check and unique constraints
  • A lot of indexes used - often more than 3-5 indexes per table