Robert
|
| Posted: 03/15/2002, 5:14 PM |
|
Scenario:
I've got a live site built with CodeCharge, ASP and an Access database. The database has real data. I've made some enhancements to the application that require additional fields to be added to some tables, and possibly additional tables. There is no issue with bringing the site down for a while for the upgrade.
Question 1:
How do I upgrade the database and retain all the current data ? No existing field defs will change.
Question 2:
If I decided to make this an app for public consumption, how would I enable the clients to easily accept an upgrade (presumably, they would need to do what I am asking in question 1, above.)
Thank you in advance !
-Robert
|
|
|
 |
Tom
|
| Posted: 03/18/2002, 6:59 AM |
|
There may be a more elegant way but ...
I quickly rename the database file on the server (myproj.mdb to myproj.mdb_020318 -- this is my recovery file so I can get out of trouble quickly -- just a simple rename) so that now my web app is broke and frozen in time.
I then FTP that database file to my PC, make the structure changes, ftp it back up to the server with the right name (myproj.mdb)
I usually do this at times I'm pretty sure that no one is in.
|
|
|
|
Robert
|
| Posted: 03/18/2002, 4:24 PM |
|
Tom;
Thats what I typically do as well. Make the changes to the existing DB. However, that's a bit risky with large changes and complex databases .. those with triggers, explicit constraints, etc.
I thought that there might be some tool like doing a back-up, moving over the new DB and then restoring the data into the new structure. But, I'm not an MSAccess person so have no clue if such tools exist.
Thank you for the reply..
-Robert
|
|
|
|
|
