Before SQL Server Synonyms appeared, everyone wished to simplify and enhance their database experience.
Imagine you have an application with a database that references another database from the same server. Then, a major reorganization forces your team to transfer the other database to another server.
There is no doubt your application will break. But what will you do in that case? Link the 2 servers and hardcode all the references (again) to point to the new server?Read More