2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Replication is the process of copying a database to another server, and then keeping the two copies in sync, so that they behave as near as possible.

 


Replicating data from Source means that as data is updated on the Source Database, the data is replicated within an on-premise database or Cloud area during specific increments in time.

...

Key functions of DBSync Cloud Replication are explained in the table below with descriptions of each functions.

Run Process

Actions Performed

Update Database Schema for

Source Apps

Creates Source Database schema into Target Database for the selected objects. The application will evaluate the schema difference between a particular Source instance schema and generate “ALTER TABLE” command to add the columns. The system will not remove any existing columns for a given table to maintain historical data.

Source Apps to Database

(Clean Copy)

Inserts a clean copy of selected object records into respective Database Tables & Columns. Once the command is executed, the system do a dump of all of theSource data for the selected Objects with their data and structures intact into a target database.

Source Apps to Database

(Incremental)

Performs an incremental sync from Source to Target Database based on the changes / edits made in Source. Once initiated, the application will query all tables / objects in Source which have been created or modified since the last synch query and will perform an update or insert in Database tables based on the association between Source to Target Database table last synch Timestamp.