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
- In your Fivetran dashboard, pause all connectors that sync to the database that you want to rename.
- In SQL Server, rename the database.
- Create a new user and role with permissions to the renamed database.
- Disable the old user and role.
- In the Fivetran dashboard, update the destination setup form with the new database name, username, and password.
- Unpause your connectors.