[OT] Utility to create DDL from a database

[Ashish Kulkarni <ku...@yahoo.com>]

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 

Re: [OT] Utility to create DDL from a database

[Zarar Siddiqi <za...@utoronto.ca>]

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" <ku...@yahoo.com>
To: <us...@ibatis.apache.org>
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
> 

Re: [OT] Utility to create DDL from a database

[Nathan Maves <Na...@Sun.COM>]

Try http://www.minq.se/products/dbvis/


On Jan 19, 2006, at 12:57 PM, Ashish Kulkarni wrote:

> 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