Avatar of bibi92
bibi92Flag for France asked on

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

Avatar of undefined
Last Comment
bibi92

8/22/2022 - Mon
Ravindran Gopinathan

Sujith

Check TOAD -> compare schemas option.
ASKER
bibi92

Hi,

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

Regards

Brigitte
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
sventhan

ASKER
bibi92

Hi,

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

Regards

Bibi
sventhan

Ok.
how do you do it in TOAD?
Just curious.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
bibi92

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
sventhan

I understand the TOAD compare schema. How do you sync the difference?
another idea for comparing the schema....
https://www.experts-exchange.com/Database/Oracle/Q_23857108.html 
ASKER
bibi92

The sync script is generate automatically with toad
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER
bibi92

Hi,

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

Thanks

Regards

Bibi92
ASKER CERTIFIED SOLUTION
bibi92

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question