On Sat, Jul 3, 2010 at 2:35 PM, Hugues Van Landeghem <h.vldg@...> wrote:

> Database Worbench  www.upscene.com

Database Workbench is an OUTSTANDING tool, there is a Lite version
which is free and has 90% of all the features you need, but the Pro
version has some truly great extra. The one that I could not live
without is the ability to compare two databases's DDL. I am adding a
new sub system to a legacy system, I simply keep one copy of the DB
before any of my changes (the baseline) and compare the db with my
changes to the baseline and Database Workbench Pro will generate the
DDL script to add all my changes, including things like adding columns
and such. It is very sophsticated, it will look at the dependencies
and if there are issues it will mess with the system tables to get the
changes in without disturbing all the other existing stuff.

Oh, and the best part of all... The Firebird version of the Pro is
less than $200, all in all, it is dirt cheap when you consider you
have to drop $5000 to get the same type of comparison tool from
Microsoft for SQL Server.