🔁 Skyvia Full (Initial) Replication

🔁 Skyvia Full (Initial) Replication

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

  1. Valid Source and Target connections
  2. Target database allows table creation or modification
    ​

How to Use

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



  • When a full replication is needed after the first run (when Incremental Updates Replication is selected and the LastSyncTime parameter is present),


    you must manually reset this parameter.



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.
​
  1. ​When the Schema Changes prompt pops up
If Skyvia detects schema or settings changes in your Replication, before saving the changes, you’ll be prompted to choose:
  • Reset LastSyncTime → Performs a full reload and re-creates tables.
  • Keep LastSyncTime → Continues incremental sync; manually update the target schema if needed.

Need a Full Reload Anytime?

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


Learn More

👉 Visit the official Skyvia Replication Documentation for detailed steps and examples.

    • 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 ...

    • Replication creates extra tables in the database

      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 of the following types: dbo.Account_2ade4447_5e11_4308_9e81_5eab62d9ed52 ...

    • Skyvia Query: Easily Verify Data in Your Connection!

      Please follow the steps below to query your data in Skyvia Query: Log in to Skyvia and navigate to + Create New → Query. Select an existing connection or establish a new one for your data source. Choose the desired table or object from the Connection ...

    • Understanding Records in Skyvia Data Integration

      1.1 Understanding Records in Skyvia Data Integration A record in Data Integration represents a single row in a database table. Every integration process (Import, Replication, Export, Synchronization, etc.) handles individual records. Records also ...

    • Replication: Table '...' Schema Validation Failed (Resolving 'Absent Columns' and 'Redundant Columns' Errors)

      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: Error: "Integration failed: Table 'TableName' schema validation failed: Absent columns: 'FieldName1', ...