How can I change a ConnectionString depending on the dev or prod environment ?

[Gilbert Tordeur]

Hello,

It is about a VB2008 intranet application. It uses a SQL Server database.
The ConnectionString is defined in the
connectionStrings section of the web.config file. This application uses
ObjectDataSource objects, defined in design mode.

I would like to use a different database depending on the execution
environment (development or production).

I can test the environment by retrieving the IIS server name. I could of
course change the web.config file by hand, but every time I will publish
from dev to prod I should do the change again.Of course, a day or another
there will be a forgetting or a mistake.

Can anybody propose an automatic solution?

Thank you in advance,
Gilbert

 

[Jeff Winn]

Just use web deployment projects, you can create 1 project for each
environment you'll be deploying the web application to. Here's the link for
the RTW (Release to Web) version for VS2008.

http://www.microsoft.com/downloads/...E8-C73B-4BDD-BB1B-FE697256C459&displaylang=en

If you're using a build server, don't forget to install it on there as well
or you'll get an error when it tries to build.

 

[Gilbert Tordeur]

Thank you Jeff for your suggestion. I didn't even know the existence of this
tool.
have a good day,
Gilbert