Skyvia Full Replication - How It Works and When to Use It

Skyvia Full (Initial) Replication

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.

    • Related Articles

    • What is LastSyncTime in Skyvia?

      What is LastSyncTime? LastSyncTime is the point when Skyvia last successfully transferred data during a Replication or Synchronization. It helps Skyvia remember what data has already been delivered, so next time, only new or updated records are ...

    • Advantages of the New Replication Runtime

      Overview The new Replication runtime introduces significant improvements over the old runtime in terms of performance, flexibility, and error handling. You can enable it by selecting Use new runtime in your Replication integration settings. Key ...

    • Skyvia Query: Verify Data in Your Connection

      Overview Skyvia Query allows you to browse and verify data in any connected data source directly from the Skyvia interface, without writing complex scripts or using third-party tools. You can use the visual Builder view or write custom SQL ...

    • Replication creates extra tables in the database

      Overview In some cases, as a result of Replication, in addition to the main tables (for example, dbo.Account), empty additional tables are created in the database with names like: dbo.Account_2ade4447_5e11_4308_9e81_5eab62d9ed52 ...

    • Replication: Schema Validation Failed (Absent Columns / Redundant Columns)

      Overview If you encounter the following errors in an integration, it means the schema of your data source no longer matches the schema Skyvia has cached: "Integration failed: Table 'TableName' schema validation failed: Absent columns: 'FieldName1', ...