To replicate data

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:
  1. Identify the key fields.
  2. The Update Rule value of each field will change between None and Replace, depending on whether or not the field is a key.
     • Replace

       overwrite existing data with new data

     • None

       take no action