| Computers Forum Index » Computer - Databases » reverse engineer a data model from CREATE TABLE... |
|
Page 1 of 1 |
|
| Author |
Message |
| metaperl... |
 Posted: Thu Aug 13, 2009 1:27 pm |
|
|
|
Guest
|
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). |
|
|
| Back to top |
|
|
|
| toby... |
| Posted: Fri Aug 14, 2009 12:48 am |
|
|
|
Guest
|
On Aug 13, 9:27 am, metaperl <metap... at (no spam) gmail.com> wrote:
Quote: 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.?
What do you mean? You want to diagram it?
Quote: These statements will be coming from a mySQL database (unfortunately.
I hate MySQL. MyISAM tables dont honor REFERENCES statements).
InnoDB supports foreign key constraints (and a lot more besides), so
you will have to come up with a better reason to 'hate MySQL'. |
|
|
| Back to top |
|
|
|
| Terrence Brannon... |
| Posted: Fri Aug 14, 2009 8:51 am |
|
|
|
Guest
|
On Aug 13, 8:48 pm, toby <t... at (no spam) telegraphics.com.au> wrote:
Quote: InnoDB supports foreign key constraints (and a lot more besides), so
you will have to come up with a better reason to 'hate MySQL'.
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. |
|
|
| Back to top |
|
|
|
| Thomas Kellerer... |
| Posted: Fri Aug 14, 2009 9:43 am |
|
|
|
Guest
|
metaperl wrote on 13.08.2009 15:27:
Quote: 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.?
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)
Quote: These statements will be coming from a mySQL database (unfortunately.
I hate MySQL. MyISAM tables dont honor REFERENCES statements).
I do not "hate" MySQL but I don't like it as well.
There are better and *really* free alternatives out there
Thomas |
|
|
| Back to top |
|
|
|
| Terrence Brannon... |
| Posted: Fri Aug 14, 2009 12:38 pm |
|
|
|
Guest
|
On Aug 14, 6:43 am, Jasen Betts <ja... at (no spam) xnet.co.nz> wrote:
Quote: On 2009-08-14, Terrence Brannon <metap... at (no spam) gmail.com> wrote:
On Aug 13, 8:48 pm, toby <t... at (no spam) telegraphics.com.au> wrote:
InnoDB supports foreign key constraints (and a lot more besides), so
you will have to come up with a better reason to 'hate MySQL'.
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.
that's why there are different types, if they all had the same
features they would be the same type 
Well, MS-SQL has both features in one type... |
|
|
| Back to top |
|
|
|
| Jasen Betts... |
| Posted: Fri Aug 14, 2009 2:43 pm |
|
|
|
Guest
|
On 2009-08-14, Terrence Brannon <metaperl at (no spam) gmail.com> wrote:
Quote: On Aug 13, 8:48Â pm, toby <t... at (no spam) telegraphics.com.au> wrote:
InnoDB supports foreign key constraints (and a lot more besides), so
you will have to come up with a better reason to 'hate MySQL'.
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.
that's why there are different types, if they all had the same
features they would be the same type |
|
|
| Back to top |
|
|
|
|
