How Can I Avoid Disruptions While Renaming a SQL Server Source Database?

Question

How can I avoid disruptions, such as errors or data discrepancies, while renaming a SQL Server source database?

Environment

Connector: SQL Server

Answer

To avoid disruptions while renaming your database, follow the steps below for each connection associated with your database:

1. In Fivetran, go to your SQL Server connection page.

2. In the top right, pause the connection by setting the ENABLED toggle to OFF.

3. If your connection uses change data capture (CDC) as the incremental sync method, disable CDC in SQL Server at the database and table level.

4. Rename the database.

5. If you disabled CDC at step 3, re-enable it at the database and table level.

6. In Fivetran, update your connection's configuration with the new database name.

   i. Go to your SQL Server connection page.

   ii. Select the Setup tab.

   iii. Click Edit connection.

   iv. In the Database field, enter your new database name.

   v. Click Save & Test.

7. Resume your connection by setting the ENABLED toggle to ON.

8. Perform a full re-sync.