7.3 Schema Creation Options

Table of Contents Previous Next


7 Migration Toolkit Command Options : 7.3 Schema Creation Options

When set to true, Migration Toolkit drops the existing schema (and any objects within that schema) and creates a new schema. (By default, -dropSchema is false).
-targetSchema schema_name
Use the -targetSchema option to specify the name of the migrated schema. If you are migrating multiple schemas, specify a name for each schema in a comma-separated list. If the command line does not include the -targetSchema option, the name of the new schema will be the same as the name of the source schema.
You cannot specify information-schema, dbo, sys or pg_catalog as target schema names. These schema names are reserved for meta-data storage in Advanced Server.

7 Migration Toolkit Command Options : 7.3 Schema Creation Options

Table of Contents Previous Next