Subject Re: How to update table structure with SQL?
Author neighbour.kerry
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:

> the standard approach offered by many admin tools is a database structure comparison tool where the result is a script which updates your target database.
> These tools exist for all major databases.

Nope - not possible. This is done by the customer. They have no tools. They just run my Update program, and their database is updated.

With DBISAM, for example, they store a version number in each table. On every startup, I can now check all their tables, and check version numbers against what is current. If any of their tables are not current, I update them silently. Works great.

I know this is not possible with Firebird. But I still need the update process.

I guess you could say I am writing the tool you speak of.