Subject Re: [firebird-support] How to update a data base
Author W O
Hello Werner

Very good idea, can you give me a short example?

Thank you.



Whenever I do a new version the first thing I write is the database

> update script and it gets tested (and updated if necessary) all along
> the way of the development of that new version.
> In the database I have a table "preferences" in my case which contains a
> column which stores the database structure version number. So, when my
> application starts it checks that column and runs the necessary upgrade
> script(s) to get the database up to the level of the application.
> My update script contains DDL (alter table/view etc) and it might also
> update/insert some new data.
> Werner

[Non-text portions of this message have been removed]