The appropriate version of Oracle was first determined. The
version Oracle 7.2 was selected due to networking constraints with
legacy clients.
A script was created to generate a set of reports of the
existing data that captured all relevant attributes. Next an
export of the database was done, followed by backing up critical
configuration files. Next the new version of Oracle was
automatically installed with appropriate checks for disk space,
permissions, and swap space.
Once Oracle was installed and running, all configuration files
were restored, tablespaces created in Oracle, data imported into
Oracle, indexes recreated, and reports were run against the
imported data. The resultant reports were automatically compared
against the reports that were generated before the migration
began.
