How Can I Change the SQL Server Destination IP for an Availability Group Without Triggering a Re-Sync?

Question

I’m moving my SQL Server destination to an Availability Group with a new listener IP. Can I update the destination host in Fivetran without triggering a re-sync or creating a new connection?

Environment

Destination: SQL Server

Answer

Yes, you can update the SQL Server destination host to the new Availability Group listener IP address or DNS name without triggering a re-sync or creating a new connection, as long as the existing destination data remains intact.

To update the destination host:

1. In Fivetran, pause all connections that sync to the SQL Server destination.

   i. Go to the relevant connection overview page.

   ii. In the top right, set the Enabled toggle to OFF.

2. Complete the SQL Server migration or listener IP change.

3. Verify that the required Fivetran users, permissions, and roles exist on all replicas.

4. In Fivetran, go to the SQL Server destination page.

5. In the top right, click the more options menu, then select Edit connection details.

6. In the Host field, enter the new Availability Group listener IP address or DNS name.

7. Click Save & Test.

8. Resume the relevant connections.

Do not drop, truncate, rename, or recreate the existing destination tables during this process. Fivetran can continue syncing only if the destination data and schema remain available.