Subject | Re: How to update table structure with SQL? |
---|---|
Author | neighbour.kerry |
Post date | 2009-06-23T03:41:16Z |
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:
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.
> 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.Nope - not possible. This is done by the customer. They have no tools. They just run my Update program, and their database is updated.
> These tools exist for all major databases.
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.