|
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?
(comments are locked)
|
|
I use a wrapper I built for DBMS_METADATA to show me the DDL and then drop it in Notepad++ to do the comparison.
(comments are locked)
|
|
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. 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 '10 at 09:33 AM
Devart
(comments are locked)
|
|
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.
(comments are locked)
|
