Hi Bruce,

I understand it's a bit old question, but I just learned a new very interesting way of solving this problem (haven't tried it, though).

See here http://weblogs.asp.net/dwahlin/archive/2007/09/22/managing-asp-net-development-staging-and-production-connection-strings-without-pulling-your-hair-out.aspx

from

this discussion

http://forums.asp.net/t/1445306.aspx

>>
>>So, I'll post another thread in SQL Server forum in a sec., but just in case, how can I use two connection strings to switch between development/local?
>>
>>The connection string is in web.config
>>
>
>
>I just have them all in config.web and comment out the ones I'm not using like this...
>
>

>		<!-- TEST - SQL2005 
>			<add key="SqlConnectionString" value="MyConnectionStringTEST"/> 
>		-->
>		
>		<!-- DEBUG - SQL2005 
>			<add key="SqlConnectionString" value="MyConnectionStringDEBUG"/> 
>               --> 
>	     
>		<!-- DEV - SQL2005 
>			<add key="SqlConnectionString" value="MyConnectionStringDEV"/> 
>                --> 
>		
>		<!-- Local DB	SQL 2K 
>			<add key="SqlConnectionString" value="MyConnectionStringLOCAL2K"/> 
>		-->
>		
>		<!-- Local DB	SQL 2005 -->
>			<add key="SqlConnectionString" value="MyConnectionStringTESTLOCAL2005"/> 
>
>

>
>Bruce