I've done this a few times. Here's how I did it. It's not
a very stellar way to get it done, but it works.
You could create a new datasource, and point it to the modified
database.
You could create a new directory on the server with your new code.
This would be the new root directory of the site. Make sure the
DATASOURCE of all your queries are set to the new datasource. If
you've done it right, that should just be a matter of modifying
your app_ files.
So the new db is not being used by the live site, and you have
the udated site in a new directory.
Run your queries to move the data over to the updated DB. WHen
you're done, you can modify the root directory of the web site
to that new directory, and have a total down time of about 10 seconds.
I'd like to hear if anyone else has a better solution.
__
Erik Voldengen 6740 N Oracle Road, Ste 100
Lead Developer Tucson, Arizona 85704
HMweb 520-742-2611 ext. 111
www.HMweb.com
------------------------------------------------------------------------------
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.
