Our DBA could tell you more about how to do it, but we create scripts for
any schema, stored procedure and view modifications. We transfer those
scripts to the live site and run them in a DTS package. Voila! Schema
changes done. You need to be careful about certain modifications like adding
a bit field - it has to have a value and the script can give it a default
value.
--
Jeffrey B. Marsh
Amateurs built the Ark.
Professionals built the Titanic.
-----Original Message-----
From: Kevin Bridges [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 10: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.
