Updating a client-database
We have a big application which uses Oracle 8/9. We issue updates quite frequently. The way we do it now is like this:
One trick we use that works well is that the new version of the software detects that the database is an older version and performs the upgrade itself.
Make it a server-side app and stop the 'update the client' insanity. Problem solved.
well the word 'client' in the topic-title actually refers to 'customer'. This topic is not about updating clients/workstation, but the database at my 'client' or 'customer'
Oops, my bad. Then, uh, what Tim said, er, wrote. Yeah, that's the ticket!
Oh yeah, and if your clients have any of their own data in the databases, get insurance. Lots of it.
Well, I'm not sure what you mean by 'own-data', but the data that they store via our program is quite mission critical. Their whole business drives on our application.
I think what Tapiwa means that your upgrade script better be bullet proof and not trash the customers data.
backup the databases
Lose the zipfile. A proper installer (InstallShield, whatever) can update the software and database in one step.
Fog Creek Home