I think most DB Clients like MySQL Front, PostGres Manager etc have an
option to "Export as DDL" which does what you're asking for. The export
feature is really built into the database (eg: mysqldump). Try looking at
Aquafold (http://www.aquafold.com/) and see what it can do for you. What
you're asking for is a pretty common thing but it's specific to the
database. If you want complete database transparency, use Hibernate.
----- Original Message -----
From: "Ashish Kulkarni" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, January 19, 2006 2:57 PM
Subject: [OT] Utility to create DDL from a database
Hi
Is there any open source utility which i can use to
create DDL from an existing database, so i can use it
to run to create tables on other database.
This utility should be smart enough to create DDL
statements for tables with primary key, before tables
with foreign key.
That way when i run the DDL to create tables on other
database there wont be referential integrity errors.
Is there some thing like this out in market.
Also is there a open source utility to run SQL
statemens againts database
Ashish
A$HI$H
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
