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

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

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/d...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" <gilbert.tordeur@xxxxxx> wrote in message
news:O3SArg0vIHA.4772@xxxxxx

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

"Jeff Winn" <jwinn@xxxxxx> a écrit dans le message de news:
8AFE70DC-9E60-4BF7-981B-6F9260BEE97C@xxxxxx...