How to Rename a SQL Server Database

Question

How do I rename the database and change the username of the SQL Server database that I use as destination?

Environment

Destination: SQL Server

Answer

1. In your Fivetran dashboard, pause all connectors that sync to the database that you want to rename.
2. In SQL Server, rename the database.
3. Create a new user and role with permissions to the renamed database.
4. Disable the old user and role.
5. In the Fivetran dashboard, update the destination setup form with the new database name, username, and password.
6. Unpause your connectors.