Hello,
It is about a VB2008 intranet application. It uses a SQL Server database.
The ConnectionStrin g is defined in the
connectionStrin gs section of the web.config file. This application uses
ObjectDataSourc e 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
2  1776 
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" <gi************ *@jci.comwrote in message
news:O3******** ******@TK2MSFTN GP03.phx.gbl...
Hello,
It is about a VB2008 intranet application. It uses a SQL Server database.
The ConnectionStrin g is defined in the
connectionStrin gs section of the web.config file. This application uses
ObjectDataSourc e 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
Thank you Jeff for your suggestion. I didn't even know the existence of this
tool.
have a good day,
Gilbert
"Jeff Winn" <jw***@nospam.c oma écrit dans le message de news: 8A************* *************** **...icrosof t.com...
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" <gi************ *@jci.comwrote in message
news:O3******** ******@TK2MSFTN GP03.phx.gbl...
>Hello,
It is about a VB2008 intranet application. It uses a SQL Server
database. The ConnectionStrin g is defined in the
connectionStri ngs section of the web.config file. This application uses
ObjectDataSour ce 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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: BenignVanilla |
last post by:
I have been using the index tuning wizard to review some of my stored procs,
and views. So far most of my indexes have been set up well, but I am curious
as to how they would look under a production system load. I was thinking of
running a profile for about 30 minutes or so on the prod system, and then
using that profile for the index tuning wizard to see what it says.
Would this be of value?
Can running a profile on a prod system be...
|
by: Pantazis Pantazi |
last post by:
Hi Listers,
I need your advice on how to implement our change management
procedures for the databases that we have through CA ERwin.
We have 5 environments (Test,Integ,Prep,Educ,Prod) and all objects are
updated through CA ERwin.
When we initialy decided the process, we used 14 different stages
until the object is created in all 5 environments and obtained all
|
by: collinm |
last post by:
hi
i would like to take a string and parse it to put her value in a tm
my struct:
typedef struct production_s
....
struct tm tmbStartRun;
struct tm tmbEndRun;
|
by: wilson |
last post by:
Hi. I'm new in VB.NET. I would like to ask a question.
How to change ConnectionString for DataSet at runtime?
Because I want to change the dBase data file directory according to the
program installed directory of user choice.
The DataSet is created using wizard at design-time.
Thanks for your help.
|
by: Arpan |
last post by:
I created a System DSN named "NETData" for a SQL Server 2005 Express
database. Now to make use of this System DSN to access records in the
DB table, this is how I framed the ConnectionString:
Dim sqlConn As SqlConnection
sqlConn = New SqlConnection("DSN=NETData")
But the following error gets generated pointing to the above line:
| | |
by: Sankalp |
last post by:
Hi,
I am using VB 2005. My application has many data bound controls. The
connection is stored in the app.config file.
I want the application to start with a default connection string and
while during the runtime, the user can click on a button and change the
connection string without exiting the application.
I would really appreciate any sort of help.
|
by: Michael Moreno |
last post by:
Hi,
We have an app that is made of many exes (WinForms and Win32 app).
All those exes share and read their DB connection string from the
registry. This guarantees that all the exes use the same DB.
With .Net the connection string is in the app.config file as soon as
you use the design time functionality to bind data to grids as an
example. So when you have 20 exes you have 20 app.config and the
|
by: Dan |
last post by:
H,
i want to use for one specific application the default membership provider
as defined by default in machine.config, except one element: i want to use
requiresUniqueEmail="false" instead of the default configuration in
machine.config (which is set on "true").
So i did this in the web.config of the application:
<membership defaultProvider="MyMembershipProvider">
<providers>
|
by: TJ |
last post by:
When an error is thrown in an async postback I am handling the error
message in an endRequest function. I retrieve the error message from
args.get_error().message, and display it in a friendly DIV. This was
working as expected in my development environment, but when I deploy
it to Production the exception message return from
args.get_error().message is always a generic message.
For example if a cast error is thrown in my dev environment...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
