Start Free Trial

asked on 1/27/2009

Script oracle for compare two schema ddl and dml

Hi all,

I search a script for generate a sync ddl and dml between two schemas.

regards

Bibi92

Oracle Database

Last Comment

2/13/2009

Ravindran Gopinathan

1/27/2009

Some third party tools could be used.

http://www.dkgas.com/oradbdiff.htm
http://www.impacttoys.com/
http://www.softtreetech.com/dbtools/

1/28/2009

Check TOAD -> compare schemas option.

1/28/2009

ASKER

Hi,

Thanks, I can't use tool.
I search to have an idea for scripting schema diff.

Regards

Brigitte

1/28/2009

Use DBMS_METADATA to extract the ddls...
check this out...
http://pandazen.wordpress.com/2008/02/09/using-the-dbms_metadata-package-to-extract-all-the-schema-ddl-with-one-call/

1/28/2009

ASKER

Hi,

Thanks but how generate the diff script for upgrade the other schema like Toad.

Regards

Bibi

1/29/2009

Ok.
how do you do it in TOAD?
Just curious.

1/29/2009

ASKER

Hi,

With toad, it is possible to use the tool database-Compare schema but I search a script with the same functionnality, toad isn't free.

Thanks

Regards

1/29/2009

I understand the TOAD compare schema. How do you sync the difference?
another idea for comparing the schema....
https://www.experts-exchange.com/questions/23857108/how-to-write-batch-file-to-compare-two-schemas.html

1/29/2009

ASKER

The sync script is generate automatically with toad

2/8/2009

ASKER

Hi,

I search always a solution to compare dml between two schemas.

Thanks

Regards

Bibi92

ASKER CERTIFIED SOLUTION

2/13/2009

Blurred text

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Oracle Database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

81K

Questions

--

Followers

--

Top Experts

Get a personalized solution from industry experts

Ask the experts

"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23
"Your help has saved me hundreds of hours of internet surfing."
@fblack61
"Just a dang good service!"
@golferski
"Worth every penny."
Steve Hougom
"It’s been a life saver."
Maria Halt
"Best support site I’ve seen!"
Bob Schneider
"I would be lost without them."
@fblack61
"Saved my job multiple times."
Walt Forbes
"I love this site."
Maria Duwe
"Friendly respectful help."
Andrew Kowtalo
"Such top-notch experts."
@magento
"The best money I have ever spent."
@rwheeler23
"Beyond any comprehensible value"
George Morris
"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23

Read over 600 more reviews

TRUSTED BY