Is there a way for me to have one sql server host name but have many sql servers using the same hostname. I hope there is something for this.
2012 sql server - hostname - server1 - has databases, apple and orange on it
2014 sql server - hostname - server2 - has databases, one and two on it
2016 sql server - hostname - server3 - has databases , car and truck on it
i would like all the connection strings to be BigSqlServer and then the database name
ie BigSqlServer\apple - actually forwards it to Server1\apple
ie. BigSqlServer\truck - actually forwards it to Server3\truck
the other thing i would hope to do is to move a database from one server to another and leave not have to worry about client connections