Peoplesoft database migration involves transfer of table definitions and data from 15,000-25,000 tables to another database platform.

• Migrating Peoplesoft from Microsoft SQL Server
  • Peoplesoft's SQL Server database contains more than 15,000 tables in one [dbo] schema.
  • NOT NULL constraint is defined for all columns
  • Data types - CHAR, SMALLINT, INT, DECIMAL and DATETIME
  • No Default values defined on columns (except a few columns)
  • No primary and foreign keys are used
  • No check and unique constraints
  • The total number of indexes is roughly equal to the total number of tables