Migration Database Analyzer (P98888)

Graphic describes the Migration Database Analyzer program

During the direct migration process, data is copied from Oracle's JD Edwards World files to Oracle's JD Edwards EnterpriseOne tables. Indexes are created for the JD Edwards EnterpriseOne tables. Each table in JD Edwards EnterpriseOne has a primary key, which means that duplicate records are not allowed. If there are duplicate records or other issues with the JD Edwards World data file being copied over, the copy to JD Edwards EnterpriseOne table fails.

The purpose of the Migration Database Analyzer (P98888) program is to identify JD Edwards World files that violate JD Edwards EnterpriseOne index constraints. The program identifies duplicate records and other issues in the JD Edwards World files. You then need to clean up the JD Edwards World records before beginning the Direct Migration process.

The program uses SQL scripts to create the indexes. A report is produced indicating if the index created successfully or if there were errors in trying to create the index. The report also shows errors such as duplicate records in the file, which prevent the index from being created.