Can I Change the Incremental Sync (Update) Method on an Existing Connection?

Question

Can I change the incremental sync (update) method on an existing connection?

Environment

Connector: MySQL or MariaDB

Answer

Yes. You can change the update method for your existing connection from Fivetran Teleport Sync to Binary log, or vice versa.

To change the update method:

1. In your Fivetran dashboard, open your connection.
2. Navigate to Setup > Edit connection.
3. Select the Update Method.
4. Save your changes.

After changing the update method, a full historical re-sync of the entire connection is required to maintain data integrity. You can trigger the full re-sync at a convenient time from the Setup tab.

Cause

Each update method uses a different incremental cursor. Switching between update methods creates an incremental cursor “gap” in change tracking. A full re-sync ensures that Fivetran rebuilds a complete and accurate snapshot of your dataset before resuming incremental updates.