The Table Options Dialog Box

Restriction: This topic applies to Windows environments only.

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.