Okay, say your site resides on two separate servers Server1 and Server2 ...
In your app_globals.cfm,
<CFIF HTTP_HOST eq "Server1">
{your application-wide variables for this server, such as...}
<CFSET request.dsn = "database1">
<CFELSEIF HTTP_HOST eq "Server2">
{your application-wide variables for this server, such as...}
<CFSET request.dsn = "database2">
{and you could keep doing this for every server you got}
</CFIF>
So there, your app_globals.cfm will dynamically set the variables to match
whatever server its running on, which should cover your needs...
Alan McCollough
Web Programmer
Allaire Certified ColdFusion Developer
Alaska Native Medical Center
> -----Original Message-----
> From: Kevin Bridges [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, November 15, 2000 9:06 AM
> To: Fusebox
> Subject: Site Version Switching
>
> Does anyone know of some "magic technique" (<-funny term) somewhere that
> would allow for instant switching from a live site to a new version of a
> site? The problem doesn't lie with the actual pages or media ... that's
> cake, it lies in the databases. Some versions may incorporate schema
> changes that make replication of the database that has the current
> information in it very difficult if not impossible. The goal is to not
> lose
> the information clients may be entering into the site all the way up until
> the second the new database takes effect. If the database is just
> switched
> then there may be pertinent information in the old database that will not
> be
> present in the new database.
>
> Currently we just go offline in the wee hours of the morning to make these
> changes which impacts overseas clients and that's just not cool.
>
> I'm curious what solutions have been utilized by people on the list and
> how
> effective those solutions are.
>
> Thanks!
>
> --------------------------------------------------------------------------
> ----
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
