> Still not possible, but it sounds like something to look at. If I can see
> what script they generate, it might be useful.
>
> The problem is I do not have the customer's database. I have no idea what
> version they have either, since Firebird does not contain version
> information. I also use a few databases here - production, testing, etc. I cannot
> generate this difference script against all these databases.
>
> The idea is run a script to update ANY database to the current version, no
> matter what the customer has.
>
> I can do it if I know a certain object exists - ie can I check if a table
> or column exists in SQL?
>
> Could I do something in a Procedure perhaps?

For the future, it might be more advisable to keep better track of the database changes and the DDL to use to apply those changes. Keep those changes inside your software. Track the version numbers of the database schema and apply the updates incrementally.

For now, you might be better of creating a new database with the upgraded metadata and then transfer the data from old to new.
--
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01