Executing a migration with a command options file v55

After you create the options file, reference it when executing the migration command:

./runMTK.sh -optionsFile <options_textfile> <schema_scope>

You can specify all options in the file or use a mix of the command line and the options file to specify the migration parameters.

Provide the scope for the schema migration

Specify the scope of the schemas to migrate:

• If you want to migrate all schemas, add the -allSchemas option at the command line or add allSchemas in your options file. For both methods, this option must be the last parameter.

• If you want to specify a subset of schemas, specify the schemas you want to migrate at the command line with no preceding option and as a comma-separated list. Schema specifications must be the last parameter at the command line.

See Migrating schemas for more information on <schema_scope>.

Here are some examples for specifying all options in the file.

Migrate a schema with specific tables

Content of the options_textfile text file:

tables comp_schema.emp,comp_schema.dept,finance_schema.acctg

Syntax of the migration command:

./runMTK.sh -optionsFile options_textfile schema1

Command line equivalent:

./runMTK.sh -tables comp_schema.emp,comp_schema.dept,finance_schema.acctg comp_schema,finance_schema

Use options file to exclude tables and include functions

You can use the options file to separate table names from configuration options. You can also use comments to clarify why parameters are used.

This example excludes tables and includes functions. It shows some comments to explain why tables are excluded.

Content of the excludeInclude.options text file:

# finances
excludeTables comp_schema.emp,finance_schema.jobhist

# temporary, #MIGRATION-123, ask Ben
excludeTables temp_schema.temp_table

excludeTables more_schema.more_tables

funcs finance_schema.add_two_numbers

Syntax of the migration command:

./runMTK.sh -allTables -optionsFile excludeInclude.options -safeMode -connRetryCount 7  schema1

Command line equivalent:

./runMTK.sh  -allTables -excludeTables comp_schema.emp,finance_schema.jobhist,temp_schema.temp_table,more_schema.more_tables -funcs finance_schema.add_two_numbers -safeMode -connRetryCount 7  schema1

Offline migration

Run an offline migration with all schemas.

Content of the options_textfile text file:

offlineMigration file_dest
allTables
schemaOnly

Syntax of the migration command:

./runMTK.sh -optionsFile options_textfile -allSchemas

Command line equivalent:

./runMTK.sh -offlineMigration file_dest -allTables -schemaOnly -allSchemas