The Table Options Dialog Box

The Table Options dialog box is used to specify destination parameters and define objects you want migrated with the selected table. You can also use this dialog box to determine how to handle duplicate migrations and how to commit data records.

The Table Options dialog box contains the following controls:

Source Displays information about the selected source table.
  AuthID Displays the owner of the source table.
  Table Displays the name of the source table.
  Tbl Space Displays the table space name for the source table.
  Database Displays the name of the database the source table was selected from.
Destination Use the Destination group box to specify information about the destination table.
  Auth ID Enter the AuthID associated with the destination table. Changing this field assigns a new owner to the destination table.

If you want Migrate to use the source table's Auth ID by default, select the Default To Source checkbox next to the Auth ID text box in the Default Options dialog box before you select Table Options; Migrate will then automatically populate this field with the proper default value. Otherwise, you will need to specify an Auth ID by typing it in text box.

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

If you want Migrate to use the name of the source table space by default, select the Default To Source checkbox next to the Tbl Space text box in the Default Options dialog box before you select Table Options; Migrate will then automatically populate this field with the proper default value. Otherwise, you will need to specify a table space name by typing it in this text box.

  Database Enter the database name for the destination table.

If you want Migrate to use the name of the source database from which the source table is selected by default, select the Default To Source checkbox next to the Database text box in the Default Options dialog box before you select Table Options; Migrate will then automatically populate this field with the proper default value. Otherwise, you will need to specify a database name by typing it in this text box. If this field is left blank, the default database name "DSNDB04" is used.

  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.
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.
Data Options Use the Data Options group box to specify how much data should be migrated and to specify a commit rate.
  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.