# Comparision of schemas

**URL:** <https://forums.toadworld.com/t/comparision-of-schemas/9720>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [July 23, 2010, 9:57am UTC](https://forums.toadworld.com/t/comparision-of-schemas/9720 "2010-07-23T09:57:02Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [July 23, 2010, 9:57am UTC](https://forums.toadworld.com/t/comparision-of-schemas/9720/1 "2010-07-23T09:57:02Z")

</div>

Hello all,

Am the new member to this group.

I want to know how to compare the scripts of two different schemas.

Actually, am asked to sync up the DDL changes in two different schemas. Suggest me the best way how I can do it by TOAD or Pl/SQL Developer tools.

Quick response is appreciated

Thanks all!

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [July 23, 2010, 10:08am UTC](https://forums.toadworld.com/t/comparision-of-schemas/9720/2 "2010-07-23T10:08:02Z")

</div>

Have you looked at Database \> Compare \> Schemas?

It will build a synch script, but you need the DB Admin module to access the  
script. Otherwise you can view the differences report.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [July 23, 2010, 10:22am UTC](https://forums.toadworld.com/t/comparision-of-schemas/9720/3 "2010-07-23T10:22:18Z")

</div>

I believe I have the DB Admin Module to access the script.

I see the following screen as per your instruction. I see Reference Schema(Source) -\> Connection --\> schema and there is a check box saying Create schema definition file. And then, down there is Schema Definition file again. Can you please guide me how I should proceed

Or is there any online manual which can give me instructions how to navigate, please suggest.

Appreciate your help!

Thanks!

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [July 23, 2010, 10:30am UTC](https://forums.toadworld.com/t/comparision-of-schemas/9720/4 "2010-07-23T10:30:54Z")

</div>

Watch the movie J

[http://www.toadworld.com/KNOWLEDGE/ToadKnowledge/CoffeeBreakBytes/tabid/73/TID/23](http://www.toadworld.com/KNOWLEDGE/ToadKnowledge/CoffeeBreakBytes/tabid/73/TID/23)  
7/cid/71/Default.aspx

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [July 23, 2010, 10:46am UTC](https://forums.toadworld.com/t/comparision-of-schemas/9720/5 "2010-07-23T10:46:51Z")

</div>

This is really helpful. Thanks Jeff!

Regards!