What is your preferred schema comparison and synchronization tool for Oracle?

If you ever have to compare schemas and create migration scripts how do you do it? Do you have a tool that works well for you or do you do this by hand?

more ▼

asked Oct 27, 2009 at 11:34 AM in Default

David Atkinson gravatar image

David Atkinson
357 15 19 22

To clarify, as Red Gate is moving into this space, as product manager I'm curious to know what current techniques and solutions are already in use.
Oct 29, 2009 at 11:41 AM David Atkinson
(comments are locked)
10|1200 characters needed characters left

5 answers: sort voted first


I'm a fan of PL/SQL Developer from Allround Automations. This includes a basic schema object comparison tool and can copy object definitions between schema. I use it occasionally for comparing and copying selected objects, rather than entire schema.

I should also note that I'm a developer, not a DBA, so my need for and use of such tools is limited.

Good luck,


p.s. I'd appreciate a vote up, so I can develop my street cred here. Thanks.

more ▼

answered Oct 29, 2009 at 12:12 PM

StewStryker gravatar image

150 3

(comments are locked)
10|1200 characters needed characters left

Our DBAs use Oracle Enterprise Manager for schema compare. For Schema upgrade we use a home grown system where developers write incremental schema change scripts, check in version control and the CI build runs all the change scripts. A record of which scripts have already been run before are kept in a table and they are not run again. Stored Procs, functions etc are always overwritten with the latest version in each build.

more ▼

answered Nov 05, 2009 at 05:14 AM

pratikk gravatar image

106 1

(comments are locked)
10|1200 characters needed characters left

Probably one of Toad's most popular features, Schema Compare (and Synch). Look forward to the competition and innovation David!

more ▼

answered Nov 03, 2009 at 03:48 PM

HillbillyToad gravatar image

1k 2

We're looking forward to it too! :)
Nov 05, 2009 at 08:49 AM David Atkinson
(comments are locked)
10|1200 characters needed characters left

You can try PowerDIFF for Oracle. Works for STRUCTURE and DATA comparisons. See http://www.orbit-db.com.

more ▼

answered Jan 12, 2010 at 07:04 AM

Stefan gravatar image


(comments are locked)
10|1200 characters needed characters left

Red Gate now has Schema Compare for Oracle available for download. The tool is designed to compare and synchronize the schemas of Oracle databases. Version 1.1 of the product suppports Oracle 9i, 10g and 11g

Download your 14-day free trial from http://www.red-gate.com/products/schema_compare_for_oracle/index.htm

Thanks, Tom

Tom Harris - Red Gate Software Ltd.

more ▼

answered Jun 17, 2010 at 12:47 PM

Tom Harris gravatar image

Tom Harris

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 27, 2009 at 11:34 AM

Seen: 980 times

Last Updated: Oct 27, 2009 at 11:34 AM

Related Questions