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.aspxfrom
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
If it's not broken, fix it until it is.
My Blog