Migrating to a New Destination

Use Case/Scenario:

You need to change the destination you are syncing data to through Fivetran. This could be because you are switching providers (ex: Snowflake to BigQuery) or because you are changing the region your destination is in. This requires a complete data migration from one destination to another.

Fivetran Recommendation:

We recommend a phased approach that allows you to seamlessly migrate your data without any downtime to reporting or analytics that Fivetran data is powering. It is not possible to move a connector from one destination to another without doing a historical re-sync. 

1. Create a new Fivetran destination:
• Managing and Adding Fivetran Destinations
2. Re-create all active connectors in the new destination:
• Use Fivetran API to Clone Connectors
• If you have many connectors that you need to copy to a new destination, or are not familiar with using our API, please reach out to support for Fivetran assistance
3. Initiate historical syncs for the new connectors.
4. Validate data in the new destination.
5. Update your production reporting and analytics to use data from the new destination.
6. Disable the connectors in the old destination.

Considerations:

Historical Syncs

• Prioritize database connectors and other application connectors that will sync large amounts of data and will take longer to complete a historical sync

Validating Data

• Compare counts by date between the old and the new destination
• By checking the relevant Release Notes, ensure no connectors have had version upgrades since you created the original connectors in the old destination 

Re-Creating Connectors

• If you need to migrate more than 20 connectors to a new destination, the Fivetran Support team may be able to help you do that on the backend