Are CNAME Aliases for connection strings a good idea?

by SwissCoder   Last Updated February 11, 2019 09:06 AM

To be very flexible and move DBs around servers, we came up with the idea of using an alias per DB. So by changing a DNS entry, we can route all queries to a different DB without changing the connection string or re-deployment of the respective client application.

Are there any known drawbacks to this?

So far it seems to be quite a smart idea. Is it?

Related Questions

Updated May 17, 2018 13:06 PM

Updated January 08, 2018 11:06 AM

Updated June 17, 2017 14:06 PM

Updated August 05, 2019 11:06 AM

Updated May 17, 2018 15:06 PM