Will
I'd definitely download it & upload it again when the site isn't busy,
if possible. Make sure you know exactly what steps you have to carry out
& how long they will take. Do a dummy run first.
A variant of Murphy's Law says that DBA operations only go wrong when
you're working directly on live tables.
If you don't want to lose data, you're going to have to lock people out
of that part of the site. You could code in a temporary message explaining
what's happening.
Nick
-----Original Message-----
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 14, 2000 10:31 AM
To: CF-Talk
Subject: Making changes to a live Database
Hi,
I have a small change to make to a live database (create a new column in a
table) which is in Access. I don't really want to download it and upload it
again, as I will undoutedly lose data (or visitors will get an error). So I
was wondering what people's experiences are of this kind of situation and
how best to handle it.
Rgds
Will
www.localbounty.com
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
