9.3 About the MIGRATEADVISOR Command

You can run the CPAT command in SQLcl using ma or migrateadvisor.

This command inclues the following sub-commands:

  • Properties: Generates a target properties file for Oracle or Autonomous Database that provides instance-specific analysis.
  • Advise: Analyzes the database and produce reports containing information to assist in a successful migration.
  • Info: Shows version information for CPAT.

Syntax

migrateadvisor help [examples|syntax] | 
advise {{-targettype,-t} {ATPS|ATPD|ADWS|ADWD|DEFAULT} } [<-optional-argument>,...] | 
properties [<optional-argument>,...] |
info

The following table lists the required and optional arguments for advise.

Argument Description Default
Required
-targettype,-t

(ATPS|ATPD|ADWS|ADWD|DEFAULT}

The type of target database to analyze for migration.

 None
Optional
-analysisprops,-a  

<propertyFile>  

The path and name of a properties file.

Note:

The full path is optional. If the full path is not specified, cd <path> is used as the root. If cd <path> is not specified, then the launch path is used as the root.

A properties file that was created using the properties sub-command while connected to the target database.

 None
-excludeschemas,-x

<schema>[,...]

The schema or comma-separated-value list of schemas to exclude from analysis.

 None
-full, -f

[TRUE:FALSE]

Execute the full set of tests.

FALSE when -schemas is not specified, otherwise the default is TRUE
-maxrelevantobjects,-m

<maxRelevantObjects>

The maximum number of "relevant objects" to be included in all reports.

This option overrides -maxtextdatarows for TEXT reports.

 Include all objects
-maxtextdatarows,-n

<maxTextDataRows>

Relevant object rows to be included in  text reports (does not apply to JSON reports).

 -maxrelevantobjects if specified, otherwise all relevant objects are included.
-migrationmethod,-mm

{DATAPUMP|DATAPUMP_DBLINK|GOLDENGATE}[,...]

A comma-separated-value list of methods or tooling that will be used to do the migration. Example: DATAPUMP, GOLDENGATE

 DATAPUMP
-outdir,-o

<directory>

Identifies location for log and report files.

Current SQLcl directory
-outfileprefix,-p

<outFilePrefix>

A prefix to the standard base file name of "premigration_advisor_report".

No prefix
-reportformat,-r

{HTML|JSON|TEXT}[,...]

Specify one or more <reportFormats> where <reportFormat> is HTML, JSON, or TEXT.

 HTML
-schemas,-s  

<schema>[,...]

The schema or comma separated value list of schemas to analyze. Example: schema1, schema2

 All schemas
-sqltext,-q Include SQL query used for checks in TEXT reports. Do not include sql text in TEXT reports. Ignored for JSON reports.
-verbose,-ve

[TRUE|FALSE]

TRUE shows additional diagnostic output.

 FALSE

The following table lists the optional arguments for properties.

Argument Description Default
-outdir,-o

<directory>

Identifies location for log and report files.

Current SQLcl directory
-outfileprefix,-p

<outFilePrefix>

A prefix to the standard base file name of "premigration_advisor_report".

 No prefix