If you chose to only run incremental sync and skip the initial sync with database restoration:
- Update the database exported timestamp in the sync_control table of T_SYNCUSER schema and post the config.
Data is loaded into sync_config, sync_control, sync_whitelist, and sync_transfer_data tables.
- Ensure data is loaded to the sync_control table in T_SYNCUSER schema.
- Check for rows with ENTRY_NAME = next.timestamp and safe.timestamp.
- After data loaded to sync_control table, stop the Jetty server: ./stopserver.sh
- Execute the following query to update the next timestamp value and commit.
update sync_control set entry_value=<DATA BASE EXPORTED TIMESTAMP> where entry_name='next.timestamp';
Note: Timestamp format should be in 'YYYY-MM-DD HH:MM:SS'
- Restart the Jetty server: ./startserver.sh -u
This process will fetch only those records from the paudit table in the source schema which are updated after the database exported timestamp.