• A temporary table is created to insert the records. This table is renamed to the final tablename at the end. In this way the target table with data is availabe almost without interruption.

• The table must have a column with a last-modified datetime.
• Step 4 and 5 are optional. These steps delete records in the target database that are not in the source database anymore.
• When the table definition in the source database has changed the target database is automatically recreated and all records are copied from source to target. See copy flowchart above.

Architecture Diagram

Flowchart

Detailed Flowchart

Data Type Mapping between different databases