x

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

Devart gravatar image

Devart
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

Leigh Riffel gravatar image

Leigh Riffel
154 8 10 12

(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

Tom Harris gravatar image

Tom Harris
1

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.

http://www.devart.com/dbforge/oracle/datacompare/

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

StewStryker gravatar image

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

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x378
x17

asked: Aug 04, 2010 at 11:25 AM

Seen: 1865 times

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