Advanced synchronization behavior

Subset synchronization is a two-step process. First, the changes in the subset are pulled into the original database, and then the subset is repopulated from the original database that uses the current version of the subset definition.

This process leads to the following synchronization behavior for records that match the subset definition:
Main Subset Synchronization result
- - No changes to synchronize so both remain unchanged.
Added - Record added to the subset if the record matches the subset criteria.
- Added Record added to the main database.
Changed Unchanged Subset record is updated.
Unchanged Changed Original record is updated.
Changed Changed The user's preference of conflict resolution behavior is used.
Note: If the changes in the main database include security changes that remove your permission to update the record, you are unable to synchronize.
Soft-deleted Unchanged
  • If the subset definition includes soft-deleted records, the record is marked as soft-deleted in the subset.
  • If the subset definition does not include soft-deleted records, the record is removed from the subset.
Soft-deleted Changed Record updated in the main database to match the subset changes.
Unchanged Soft-deleted Record marked as soft-deleted in the main database.
  • If the subset definition includes soft-deleted records, the record is marked as soft-deleted in the subset.
  • If the subset definition does not include soft-deleted records, the record is removed from the subset.
Changed Soft-deleted The record recreated in the subset including the changes.
Changed Changed then soft-deleted The user's preference of conflict resolution behavior is used.
Note: If the changes in the main database include security changes that remove your permission to update the record, you are unable to synchronize.
Changed then soft-deleted Changed The user's preference of conflict resolution behavior is used.
Note: If the changes in the main database include security changes that remove your permission to update the record, you are unable to synchronize.
Purged/Deleted Restored from a soft-deleted state Record recreated in the main database.
Purged/Deleted Unchanged Record removed from the subset.
Purged/Deleted Changed Record recreated in the main database.
Changed then Purged/Deleted Changed Record recreated in the main database but without any changes made to the main record since the subset was last populated.
Unchanged Purged/Deleted Record recreated in the subset.
Changed Purged/Deleted Record recreated in the subset.
Note: If the subset definition is changed, or records are added to the subset that do not match the criteria in the definition. New or updated records will be added to the master database and subsequently removed from the subset.