Tables

Use the options to select a data load action into your database when the configuration data is loaded for your target environment:

• Replace Tables

  The table in the target environment will be replaced with the table in the configuration.

  Caution:

  If any records exist in the target tables to be replaced, they will be lost because Replace Table selection indicates that you want to replace the table with data from the portable archive created by Configuration Assistant.

  You should always beware of data integrity concerns, especially in production data environments. See, Backing Up Your Target Database Environment.

• Replace Records

  Table records in the target environment will be replaced with the records in the configuration table.

  Caution:

  Replace Records does not clear the table before it copies. It replaces records in the target with the same key. Any new records are appended.

  You should always beware of data integrity concerns, especially in production data environments. See, Backing Up Your Target Database Environment.

• Append Records

  Only records that do not exist in the target environment will be copied from the configuration tables.

  Caution:

  You cannot create a configuration to extract and deliver an empty table. That is, you cannot define an empty table in your source environment to overwrite an existing populated table in your target environment.

  You should always beware of data integrity concerns, especially in production data environments. See Backing Up Your Target Database Environment.