Sql Server Catalog/DB pointer --

Question

I have a production server and I standardized the names of all the DBs on the server to

projectName.whatever 

The problem is I have one database named

projectName_logging

I want to rename it to

projectName.Logging 

(OCD a bit?)

The problem is there are connection strings that all say projectName_logging. Is there a way to say if a connection is projectName_logging to automatically redirect it to a catalog now named projectName.logging ?

Answer 1

As requested by the OP, I'm making my comment an answer.

Sounds like what you really want is a synonym for a database name, which doesn't exist, but you can vote for the feature here.