Upgrading from Version 9.0.1 or 9.1.0 for Oracle

Back Next

Generating the Readiness Report

To generate the readiness report, run the

readiness_start.sql

script.

Navigate to the following directory:

On UNIX. <

MDM Hub distribution directory

>/database/resources/database/migration_readiness/oracle

On Windows. <

MDM Hub distribution directory

>\database\resources\database\migration_readiness\oracle

Connect to the Operational Reference Store (ORS) schema for which you want to generate a readiness report.

In SQL*Plus, run the

readiness_start.sql

script.

Select the appropriate option to generate the readiness report:

To create a readiness report, enter

for the first option,

Check data and generate report (y/n)

If you are running

readiness_start.sql

for the first time, you must select

for option 1. The time required to perform the data check depends on the size of the schema and the number of parent records and child records.

Enter

for the second option,

Fix data issues identified by data check and generate report (y/n)

Enter

for the third option,

Regenerate report from previous data check (y/n)

Open the readiness report in a program that can open CSV files, such as Excel, to review the data issues identified for the schema.