Thanks for everyone's input on this. I'm thinking that Sean's suggestion
may work best for us. I can definitely hard code a version number into a SP
and have it move with the database and check it against the expectations of
the client program to make sure the versions match. That'll work fine.

> On 21-Mar-2008 09:19:28, firebird-support@yahoogroups.com wrote:
> > Has anyone found a way to version stamp the DDL within a Firebird
> > database?
>
> We created a simple SP named "Get_Schema_Version" which returns a
> constant version string that we have assigned.
>
> Then, whenever we make a change to the schema, we include a CREATE OR
> ALTER PROCEDURE statement, in the SQL script which update the target
> DBs, to update the SP version string value.
>
> So, that on startup our Application runs the SP and compares the
> returned string against the value it needs/expects.

Thanks again for the input.

Myles


===============================
Myles Wakeham
Director of Engineering
Tech Solutions USA, Inc.
Scottsdale, Arizona USA
www.techsolusa.com
Phone +1-480-451-7440