SAP R/3 database migration involves transfer of table definitions and data from about 25,000 tables to another database platform.

• Migrating SAP R/3 from IBM DB2
  • SAP R/3 DB2 database contains about 25,000 tables and about 4,400 views in one schema SAPR3
  • Data types - CHAR, CHAR FOR BIT DATA, VARCHAR, VARCHAR FOR BIT DATA , LONG VARCHAR, LONG VARCHAR FOR BIT DATA, INTEGER, SMALLINT, BIGINT, DOUBLE, DECIMAL, TIMESTAMP, BLOB, CLOB
  • NOT NULL constraint is defined for all columns
  • Default values are defined for all columns
  • Primary keys are widely used
  • A lot of unique and non unique indexes are used - 1 to 7 indexes per table
  • A few foreign keys are used
  • No check constraints