question

David Atkinson avatar image
David Atkinson asked

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?

schema-comparison
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
StewStryker avatar image
StewStryker answered

David,

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,

Stew

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

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

HillbillyToad avatar image
HillbillyToad answered

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

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

We're looking forward to it too! :)
0 Likes 0 ·
pratikk avatar image
pratikk answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Stefan avatar image
Stefan answered

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

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tom Harris avatar image
Tom Harris answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.