Create DB Sync system tables

The DB Sync framework needs specific SQL table to store DB Sync system data.

The DB Sync system tables store information such as apps definition, users properties, change log records, etc.

DB Sync system tables must be created in the application database, along with application SQL tables.

This operation is done from the command line with the dbsync_setup tool.

Perform the folling steps to create DB Sync system tables:

  1. Make sure that the DB Sync server configuration file is properly defined: This file is required by the dbsync_setup tool to to access your application database.

  2. Run the next command to create DB Sync system tables:
    dbsync_setup create-tables -c $DBSYNCDIR/conf/myconfig_library.json

    The table creation command will fail with an error, if DB Sync system tables already exist. Use the dbsync_setup drop-tables command, to drop the DB Sync system tables.

Tip:

During the DB Sync server configuration file setup, the DB Sync system tables can be automatically created at the end of the process, if they do not yet exist.