Subject Re: How to keep track of database version?
Author Luis Semedo Duarte
--- In, Alexandre Benson Smith <iblist@...> wrote:
> Luis Semedo Duarte wrote:
> > Hello,
> > And thank you all in advance for reading my message!
> >
> > I would like to have some kind of build version for my database.
> > This would help me keep track of changes made to the database, and it would be easier to write upgrade/downgrade scripts to specific database versions.
> >
> > Any easy way of doing it?
> > I though of going through all system tables and place triggers for insert/update/delete to increment the build number!
> >
> > My question is this, is there any easy way to do it? (without having to write triggers for all system tables)
> > If not, do i have to write triggers for all system tables? Surely, some could be ignored... (i think)
> >
> > Thank you for your time.
> > Luis Semedo Duarte
> >
> Look for messages with the following subject "Re: [firebird-support] Re:
> Logging Patches to Database" on the past week...
> Triggers on system tables would not survive a back-up/restore cycle
> see you !
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil

Thank your reply.

After reading the messages you pointed me at, i came to the conclusion that there is no automatic way to do it.
I mean, a table and some fields must be created on the database, but the actual version numbers must be updated by manually by the user!
I was looking for a way to do it automatically, that's why i was thinking of using the system tables. But you are right, triggers on system tables would not be restored after a backup on the database.

Oh well... I Guess i will have to maintain the version numbers manually!

Thank you very much for you help!
Obrigado na mesma!

Luis Semedo Duarre