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
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 D
4 matches
Mail list logo
