Subject Re: Visualising a database
Author ben_ata
--- In firebird-support@yahoogroups.com, "Kevin Lingofelter"
<kevin@a...> wrote:
> I seriously doubt FB support will show up in their new version. From
what I
> understand MySQL acquired FabForce. It is a nice looking tool
though. It is
> open source (Delphi/Kylix) so maybe some of the Delphi developers
here could
> band together and add the support...nudge...nudge...wink...wink...
>

I have two workarounds for the fact that DbDesigner does not support
anything else then MySQL.

1) We have written an XSLT stylesheet that converst DbDesigners XML
into SQL statements for Oracle. Shouldn't be too difficult to adjust
that for Firebird. I have posted that XSLT on FabForce's forum (search
for Oracle)

2) SQL Workbench/J (don't mix this with Database Workbench from
Upscene) can extract a database definition into the XML format
DbDesigner uses. It does not support everything that DbDesigner does,
but tables, primary keys and foreign keys are in the file. The initial
visual layout is far from perfect as well, and this solution does not
support roundtrip engineering. Not a perfect solution, but for a
one-time reverse engineering maybe acceptable. I'm the author of SQL
Workbench. It's free and open source, and can be downloaded from
www.sql-workbench.net

Using these two workarounds, its not necessary to connect to the
database from within DbDesigner at all.


Cheers
Thomas