I have become enamoured of SQL*Power Architect, but to reverse
engineer a data model, it needs to connect to the database. In my
case, this is not possible, but I can dump the statements used to
create the database.

Is there a (free/cheap) tool that can reverse engineer a database from
the create table statements.?

These statements will be coming from a mySQL database (unfortunately.
I hate MySQL. MyISAM tables dont honor REFERENCES statements).

On Aug 13, 9:27*am, metaperl <metap... (AT) gmail (DOT) com> wrote:
What do you mean? You want to diagram it?

InnoDB supports foreign key constraints (and a lot more besides), so
you will have to come up with a better reason to 'hate MySQL'.

metaperl wrote on 13.08.2009 15:27:
If you can start Power*Architect you can also connect to one of the embedded Java database engines. Why not run the script against e.g. H2 or HSQLDB and then connect to that "database". That will not required any "installation" of a database server and should work on any computer that has Java installed (which you have, otherwise you wouldn't be able to run Power*Architect)

I do not "hate" MySQL but I don't like it as well.
There are better and *really* free alternatives out there

Thomas

On Aug 13, 8:48*pm, toby <t... (AT) telegraphics (DOT) com.au> wrote:

Yes but it lacks the full-text indexing of MyISAM tables ... you have
some features in 1 table type and other features in the other.

Not to mention replication is harder under InnoDB.

On 2009-08-14, Terrence Brannon <metaperl (AT) gmail (DOT) com> wrote:
that's why there are different types, if they all had the same
features they would be the same type

On Aug 14, 6:43*am, Jasen Betts <ja... (AT) xnet (DOT) co.nz> wrote:
Well, MS-SQL has both features in one type...