Database Import: Select an Index

When you select the Update import mode, a unique index is required to match records from the source and destination tables. Select from the list of indices displayed for the destination table. By default, the destination table's primary index will be selected in the list.

Alternatively, click on the Custom Index Definition button to select the columns that make up a unique index.

Perform unique constraint checking before updating

In order to match new records from the input dataset with existing records in the destination table, Geobank must match one or more field values from the input record with those in the destination table.

The combination of these values must be unique, therefore the columns used for matching the records must be part of a unique index (such as the primary key).

This option should be used with caution. If the target is a database view, please be aware that the update process may fail if the complexity of the view exceeds ADO limitations.