You use fq.append.mode property in the configuration XML file to
define how and if the records are transferred to the specified target database.
Property fq.append.mode defines the way in which new data is added to the
already existing data. The property can be used with both, import and export operations.
The
fq.append.mode property takes the following values:
- create
- During import, new table is created in the target database. If the table with the same name
already exists, import fails. This value is set as default.
- overwrite
- During import, a table from the source database is imported into the target database, and if
any table with the same name already existed in the target database, it is replaced
(overwritten).
- append
- The data from the source table is imported into the target table and appended to the already
existing records. That is, if a table with the same name already exists in the target database, all
data from the source table is added (appended) to the existing table. Note that this might cause
duplicate entries in the target table. If the table does not exist in the target database, it is
created.
Example:
In the following example, there is one table in the source database and a corresponding one in
the target database. Table on source was updated with one new row.
Table 1. Table in the source database
| col1 |
col2 |
| 1 |
1 |
| 2 |
2 |
| 3 |
3 |
Table 2. Table in the
target database
| col1 |
col2 |
| 1 |
1 |
| 2 |
2 |
When you import the table from source to target using
fq.append.mode =
append then the resulting table on target will look as follows:
Table 3. Table on target after importing in
append mode
| col1 |
col2 |
| 1 |
1 |
| 2 |
2 |
| 1 |
1 |
| 2 |
2 |
| 3 |
3 |