The easiest way for you is to exploit the SET FOREIGN_KEY_CHECKS property. I
know this is supported by MySQL for sure. And something similar if not the
same, should be available with other databases too.
SET FOREIGN_KEY_CHECKS=0;
//script generated
SET FOREIGN_KEY_CHECKS=1;
Remember to set it
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 util
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
3 matches
Mail list logo
