Hi there is a export tool, but the problem it creates DDL sorted by table names, and it does not take into account any database relationships, i may have to go in manually and creates script.. for example there may be a table ABC which has a foreign key constraint with table XYZ. This database utility created DDL for ABC first and then for XYZ. So i run these DDL statements it gives error saying that table XYZ is not created. So i need some utility which will create DDL considering these constraints
Ashish --- [EMAIL PROTECTED] wrote: > Doesn't your database include such an export tool? > What database are > you using? > > Ashish Kulkarni inquired > > 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. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]