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

If you ever have to compare data and create update scripts how do you do it? Do you use DBMS_COMPARISON package for these purposes? Do you have a tool that works well for you or do you do this by hand?

more ▼

asked Aug 04, 2010 at 11:25 AM in Default

avatar image

11 1 2 2

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

3 answers: sort voted first

I use a wrapper I built for DBMS_METADATA to show me the DDL and then drop it in Notepad++ to do the comparison.

more ▼

answered Aug 07, 2010 at 04:00 PM

avatar image

Leigh Riffel
154 11 10 15

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

Red Gate is currently working on Data Compare for Oracle. The tool is designed to compare and synchronize Oracle table data. We hope to have an Early Access build available for download in September.

Register your details at http://www.red-gate.com/products/data_compare_for_oracle_eap/index.htm

Thanks, Tom

Tom Harris - Red Gate Software Ltd.

more ▼

answered Aug 25, 2010 at 08:52 AM

avatar image

Tom Harris

Recently we've released a visual tool for data comparison with functionality similar to the functionality of the DBMS_COMPARISON package and supporting all data types supported by the latter, also it forms sql scripts for update and data synchronization. But the tool's main benefit in comparison to the DBMS_COMPARISON package is that dbForge Data Compare for Oracle supports all Oracle versions from 7.3 and 8i to 11g.


Also I'll add that the tool is totally free even for commercial use.

Aug 31, 2010 at 09:33 AM Devart
(comments are locked)
10|1200 characters needed characters left

I use PL/SQL Developer as my Oracle IDE and it includes nice data and schema object comparison tools. It's from Allround Automations and we've been very pleased with it for a few years.

more ▼

answered Nov 03, 2010 at 04:38 PM

avatar image

150 3

(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.

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: Aug 04, 2010 at 11:25 AM

Seen: 2245 times

Last Updated: Apr 07, 2012 at 09:20 PM

Copyright 2018 Redgate Software. Privacy Policy