The Default Options Dialog Box

The Default Options dialog box is used to assign default migration options for tables and queries.

The Default Options dialog box contains the following controls:

Destination The options in this group box specify the default destination information for the selected table or query.
  Auth ID Enter the AuthID associated with the destination table. Changing this field assigns a new owner to the destination table.

Select the Default To Source checkbox next to this field to indicate that you want to use the source table's Auth ID by default.

  Tbl Space Enter the table space name for the destination table.

Select the Default To Source checkbox next to this field to indicate that you want to use the name of the source table space by default.

  Database Enter the database name for the destination table.

Select the Default To Source checkbox next to this field to indicate that you want to use the name of the source database by default.

If Table Already Exists Use the If Table Already Exists group box to specify what Migrate should do if the table you are migrating already exists at its destination.
  Abort Select this option if you want Migrate to terminate the migration if the destination table already exists.
  Append Data Select this option if you want Migrate to append the new table to the existing destination table. If the destination table has no primary key, all records are appended to the destination. You can use this option with the No Data option (see below) to migrate just an index.
Note:

You can end up with duplicate records if you use this option on a table without a primary key.

  Replace Data Select this option if you want Migrate to replace all existing records in the destination table with records from the source table. All data in the existing table will be deleted.
  Replace Table Select this option if you want Migrate to drop the destination table and create a new table containing the result of this migration.
  Limit Data To Select the number of records you want to copy.
  • Select All Rows to migrate all data records from the source table to the destination.
  • Select No Data to migrate none of the records from the source table to the destination. You might use this option to create an "empty" destination table (which will have a structure identical to the source) into which you can selectively copy records using Migrate's query feature. Or, you might use it to copy certain table attributes without copying any data.

    The behavior of this option depends on the following:

    • If the destination table does not exist, an "empty" table is created.
    • If the destination table exists, and the Replace Data or Replace Table option is used, the destination table's existing records are deleted and no records are copied (an "empty" table is created).
    • If the destination table exists, and the Append Data option is used, no records are copied to it (you could use this combination of options to copy just an index).
  • Select First N Rows if you only want to migrate the first N records from the source table to the destination.
  • Select Every Nth Row if you want to copy every N records from the source table to the destination.
  Commit Work After Specify the number of records Migrate should accrue before permanently writing them to disk (i.e., issuing a COMMIT statement). You can specify any number between 0 and 32,767. High Commit Work After values produce a faster migration but result in fewer records successfully written should the migration be interrupted.
Migrate

Use the Migrate group box to select the objects you want to migrate with a table.

  Primary Key Select this checkbox if you want primary-key columns in the source table to also be primary-key columns in the destination table.
  Unique Keys Select this checkbox if you want unique-key columns in the source table to also be unique-key columns in the destination table.
  Indexes Select this checkbox if you want the index key in the source table to also be the index key in the destination table.
  Foreign Keys Select this checkbox if you want foreign-key columns in the source table to also be foreign-key columns in the destination table.
  Synonyms Select this checkbox if you want any alternate names for the source table to also be alternate names for the destination table.
  Comments Select this checkbox to migrate comments in the source table to be included on the destination location table.
  Privileges Select this checkbox to migrate privileges. The privileges checkbox lets you place the same security standards on the destination tables as on the source tables.
  Distinct Type Select this checkbox to migrate distinct types used by the source table.