Wednesday, March 21, 2018
Most geeks have come across this problem.. You're collaborating on a DB and each of you have different named local SQL instances. what do you do?
Most change the connection string temporarily, then accidentally ruin someone else's setup when you accidentally commit it.
I've known devs add the web.config to the to the ignore list, loosing all other changes that may have been made to the file.
I'll just keep a set of known good configs here in this folder I'll copy in...
Well, it turns out you can set an alias to use more than one instance name...
e.g. "localhost" can resolve to ".\SQLEXPRESS"
Follow these steps to add an alias: