DDH Software, LLC Making a big world smaller






Return to Knowledgebase Home
What is the difference between Data Exchange and Sync Exchange?
Product: General HanDBase TopicArticle Number: 229Creation Date: 06/30/2003

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.


This article has been viewed 1 times.

Return to Knowledgebase Home