7.4 Schema Object Selection Options

Table of Contents Previous Next


7 Migration Toolkit Command Options : 7.4 Schema Object Selection Options

-tables table_list
Import the selected tables from the source schema. table_list is a comma-separated list of table names (e.g. -tables emp, dept, acctg).
By default, Migration Toolkit does not implement migration of check constraints and default clauses from a Sybase database. Include the ‑ignoreCheckConstFilter parameter when specifying the -constraints parameter to migrate constraints and default clauses from a Sybase database.
This option is valid only when importing an entire schema or when the -allTables or -tables table_list options are specified.
Import the table indexes. This option is valid when importing an entire schema or when the -allTables or -tables table_list option is specified.
Import the views from the source schema. Please note that this option will migrate both dynamic and materialized views from the source. (Oracle and Postgres materialized views are supported.)
-views view_list
Import the specified materialized or dynamic views from the source schema. (Oracle and Postgres materialized views are supported.) view_list is a comma-separated list of view names (e.g. -views all_emp,mgmt_list,acct_list)
-sequences sequence_list
Import the selected sequences from the source schema. sequence_list is a comma-separated list of sequence names.
-procs procedures_list
Import the selected stored procedures from the source schema. procedures_list is a comma-separated list of procedure names.
-funcs function_list
Import the selected functions from the source schema. function_list is a comma-separated list of function names.
When false, disables validation of the function body during function creation (to avoid errors if the function contains forward references). The default value is true.
-packages package_list
Import the selected packages from the source schema. package_list is a comma-separated list of package names.
-allRules

7 Migration Toolkit Command Options : 7.4 Schema Object Selection Options

Table of Contents Previous Next