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?