Configuring validation options

Oracle Cloud Infrastructure Database Migration is integrated with the Oracle Cloud Pre-Migration Advisor (CPAT) tool. CPAT analyzes the source database during validation and advises you about database features and constructs that are problematic.

CPAT provides the following benefits:

  • Warns you about any features used by your database that aren't supported in the target environment

  • Makes suggestions for remedial changes and/or parameters to use for the Data Pump export and import operations

To configure CPAT settings:

When you are creating a migration you can configure CPAT settings in the Migration resource Advanced Settings, Validation tab.

Run CPAT during validation: Enables CPAT to run during a migration validation job, in the Validate Pre-migration Advisor phase

Continue CPAT validation on error: By default, a validation job stops running when CPAT finds an issue. When checked, if CPAT finds an error, the CPAT validation will continue to its conclusion.

This setting is useful if you want to proceed with a migration if error conditions have already been reviewed and the problematic objects have been excluded, because since CPAT does not review the exclusions list, it will still report any blocking issues on objects even if they are excluded.

These settings can be changed after the migration is created. See Editing a migration.

See Cloud Premigration Advisor Tool Support in the Zero Downtime Migration documentation for more information about CPAT.