DB Sync system tables

The DB Sync framework uses its own SQL system tables to store synchronization configuration parameters and data change logs.

The DB Sync system tables need to be created in the application database.

All DB Sync system tables have a name with the dbsync_ prefix, to avoid conflicts with application SQL tables.

Description of DB Sync system tables and SQL objects:
  • dbsync_app: DB Sync client application definitions.
  • dbsync_user: End user definitions (corresponding to GIP users)
  • dbsync_atlink: app/table associations.
  • dbsync_aulink: user/app associations.
  • dbsync_ufparam: SQL data filter parameter definitions.
  • dbsync_udsinfo: The user/app/table information with last sync timestamps.
  • dbsync_log: The changes log containing synchronization and data modification events.
  • dbsync_logseq: The sequence object to create oridinal numbers in the dbsync_log table
Note:

The database user connecting to the central database from the server applications and sync service program, needs to have read/write permissions on these tables.

The dbsync_setup tool can be used to create and drop system tables. Before using this tool, make sure that the FGL and DB Sync environment is properly set.

The DB Sync server configuration file is required.

Use the dbsync_setup tool with the create-tables verb to create DB Sync system tables:

dbsync_setup create-tables -c dbsync_config.json

Use the dbsync_setup tool with the drop-tables verb to drop all DB Sync system tables:

dbsync_setup drop-tables -c dbsync_config.json