Subject Re: [firebird-support] How to keep track of database version?
Author Alexandre Benson Smith
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
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil