Sample Header Ad - 728x90

Seamless SQLServer Database Name Change

2 votes
1 answer
302 views
I need to change the name for a few databases, however the databases are used by a lot of applications managed by several different teams. It would take some time for all the applications to finish changing connections and database name references. Is there a way to allow the change to be done seamlessly? Was looking at synonyms to temporarily allow references to the renamed database but unfortunately it is only for database level.
Asked by JieLong (315 rep)
Apr 22, 2021, 09:01 AM
Last activity: Apr 22, 2021, 12:55 PM