my 2c:
We version our database structure and use a program called "Scanner" that
reads the Paradox tables in and creates a .PAS file that will re-create the
entire database structure.
When the user's database needs to be upgraded the data is backed up to a
.backup file, the entire database is recreated, and the data is loaded back
from the .backup file.
This probably doesn't apply to Interbase and so on, where you would use
scripts instead of BDE calls to create the structure, but perhaps this gives
you some ideas. We can't do it manually because our product is sold in
quantity all around the world & it has to be able to be set up by 'dummies'
(not looking forward to moving up to client/server ... any ideas?)
This should be the address for the Scanner program...
http://www.gold.com.br/~demian/
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Dennis Chuah
> Sent: Thursday, February 03, 2000 9:14 AM
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: Interbase Error : What am I missing here???
> (Interbase Newbie)
>
>
> > >Question: What do you do when you have a new release and the
> > new version
> > >requires 3 new fields in table XYZ and a new trigger on table ABC?
> >
> > I generally do the change on a development database, then run
> > it as a script on the
> > live system when I have it all working. OTOH, I generally
> > dont change a working
> > database - if I need stuff between releases, I usually have
> > so many other changes to
> > make, I have to port the data over by hand (or try and use
> > the data pump), rather
> > than just make changes.
>
> What if you have more than one client - like several dozen? What
> do you do
> then? Will you still use scripts? Or a data pump? If you don't use
> scripts then, why?
>
> Regards,
> Dennis.
>
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
