During class today we briefly talked about how you could/should store config info; such as connection strings. Basically there are 4 options;
- Use a UDC file to store your connections [bad]
- Manipulate the hosts file on your/dev computer [hack]
- Use the .config file of the service (BTSNTSvc.exe.config) [ok]
- Use the SSO database that comes with BizTalk [best practice]
Now; if your BizTalk installation is just using one server the .config file option might be the best option for you, but for most larger installations you’re better of using the SSO database. I did a little digging around and found a blog post by Jon Flanders describing in detail how to do this; Great! I haven’t tested it yet, but it looks solid so far.