Database design tool

[Daniel B. Thurman]

>From: fedora-list-bounces at redhat.com
>[mailto:fedora-list-bounces at redhat.com]On Behalf Of Mark Eggers
>Sent: Tuesday, November 08, 2005 12:17 PM
>To: fedora-list at redhat.com
>Subject: Database design tool
>
>
>A while back I used to use fabForce's DB Designer 
>[http://www.fabforce.net/dbdesigner4/].  This is a nice tool 
>for designing databases.
>
>I still use this tool under Windows/2000, but it no longer 
>appears to work under Fedora Core 4.  The compiled software 
>references older versions of several libraries.
>
>Before I download the source, track down the dependencies, and 
>try to build this tool, does anyone have other suggestions for 
>freely available database design tools?
>
>I know - I can always create the diagram in Dia, then write my 
>own SQL to create the tables and indicies.
>
>I took a quick look at OpenOffice's database tool, and while I 
>can connect to databases via JDBC drivers, it doesn't look 
>like I can describe foreign keys and referential constraints.
>
>Thanks in advance.
>
>/mde/
>

Another DB tool, Java based, is DbVisualizer.  There is a free version
and there is a professional version.  Seems like it can be used on any
platform that supports Java.  I like this one because it appears snazzy
and professionally well done, and not bad for the free one but need to
pay for the professional one if you want the useful tools and wizards.
Seems to support nearly all database types, providing there is a JDBC
connector/driver for the db in question.  I can use this for MSSQL, MySQL,
Oracle, and many others.

Dan

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.12.8/162 - Release Date: 11/5/2005