When I need to update my database can I just FTP over the old one?
Yes and No. Because of the way ColdFusion accesses ODBC databases, you will often be unable to copy over a database. More importantly, your database is 'live,' meaning there is a constant possibility someone will try to access your database while you are copying over your new database. This can often lead to a corrupted database.
To get around these issues, we ask all clients to copy any new databases to the server under a different name than the active database. Once copied, they can quickly rename the old database and put the new one live. Of course if there is ever a problem, we ask clients to contact us at firstname.lastname@example.org.