HanDBase Data Exchange allows the import and export of data between HanDBase and another source.
For example, Data Exchange for MS Access allows you to import data from an Access table to a new or
existing HanDBase database. Data Exchange also allows you to export data from a HanDBase database
to a new or existing table in Access. An import or an export will not pay attention to the records
that already exist. You will have the option of adding (appending) the records to the existing
source. However, if some records exist in both the HanDBase database and the Access table, this
will result in duplicates of those records. If you do not choose to append the records during
import or export, the existing records will be replaced by the incoming records.
Sync Exchange will merge the data between HanDBase ad another source. For example, Sync Exchange
for MS Access allows you to synchronize the data between a table in Access and a database in
HanDBase. This means that changes to existing records in either Access or HanDBase will be
reflected in the other source after Sync Exchange runs. This will include additions of new records
or deletions of existing records. This differs from an import or an export because Sync Exchange
keeps track of the records that already exist, and watches for changes to the existing records. If
a change occurs to an existing record in HanDBase, then Sync Exchange modifies the other data
source, and vice versa. |