Subject RE: [firebird-support] Modification of the DB structure
Author Alan McDonald
> Hi,
>
> I'm new to FB, and I have many questions about it (I'll ask for the
> others later ;-))
>
> As I understood, all triggers and stored procs are compiled (it's the
> one I'm wondering about at the moment):
> so, if I've got a "evoluting" DB with modification of the structure
> with time, how can I make "automatic" modifications to the customer
> structure ? I mean, if I have to change StoredProcs or add new ones
> for example, how can I declare it on my customers DB and recompile
> them by code, without having each time to give a "new" structure and
> copy the data to the one ?
>
> Thanks for informations / suggestions,
>
> David

If you use a decent admin tool e.g. IBExpert, then you will have a
DBComparer tool built-in. Do your development and keep a copy of the
database as you have distributed. When time comes to ditribute your updates,
run the comparer tool. It will generate a script to run on each client which
will automatically bring your client dbs up to date.
Alan