Subject | Re: Visualising a database |
---|---|
Author | ben_ata |
Post date | 2004-12-27T10:52:10Z |
--- In firebird-support@yahoogroups.com, "Kevin Lingofelter"
<kevin@a...> wrote:
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
<kevin@a...> wrote:
> I seriously doubt FB support will show up in their new version. Fromwhat I
> understand MySQL acquired FabForce. It is a nice looking toolthough. It is
> open source (Delphi/Kylix) so maybe some of the Delphi developershere 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