Production database users can specify insert, update, and delete actions for tables that already exist. The instructions for replicating data are the same as Migrating Certain Rows and Columns, with the following exceptions:
- In the Query Options window, choose one of the following options from the "If table already exists" group:
-
Update No Insert
update the information only if a row with the key already exists
-
Update Insert
update the existing row, or insert new row
-
Delete Match
delete existing matching row
- In the Define Query window, if you selected either the Update No Insert option or the Update Insert option, click the Update Rule button. In the Query Update Rules window:
- Identify the key fields.
- The Update Rule value of each field will change between None and Replace, depending on whether or not the field is a key.
