Hello Werner

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

Thank you.

Greetings.

Walter.




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]