Overview

Full Replication creates a complete copy of your source data in the target database. Use it for the first replication run, after schema changes, when refreshing all data, or if you encounter duplicate records.

Requirements

• Valid Source and Target connections.
• Target database allows table creation or modification.

How to Use

First-time replication run

When running replication for the first time (without LastSyncTime set), Skyvia performs a Full (Initial) Replication, loading all selected source tables into the target. Make sure the Create Tables and Drop Tables checkboxes are selected in the replication settings.

Full replication after the first run

When Incremental Updates Replication is selected and the LastSyncTime parameter is present, you must manually reset this parameter to trigger a full reload.

Or select Reset LastSyncTime in the pop-up window after making changes in your Replication. This forces Skyvia to reload all data again and recreate tables.

Schema changes prompt

If Skyvia detects schema or settings changes in your Replication, before saving the changes you will be prompted to choose:

• Reset LastSyncTime - performs a full reload and recreates tables.
• Keep LastSyncTime - continues incremental sync; manually update the target schema if needed.

Need a Full Reload for Each Run?

Enable Resync mode in the table configuration to force a full load for specific tables, without resetting the entire integration.

Useful Links

• Skyvia Replication documentation