Compare data with different structures

dbForge Data Compare for Oracle is a powerful, fast, and easy tool for comparing and synchronizing Oracle databases. It helps you quickly compare data in tables, find the differences at a glance, and generate a script to effortlessly synchronize data. All this is done in a clear graphical interface. Database professionals use dbForge Data Compare for Oracle to: save time with automatic table data comparing & synchronization, analyze data differences and generate reports, quickly reconcile two databases that went out of sync, copy look-up data from development databases to production, generate SQL*Plus-compatible synchronization scripts and more.

Updates in V2.0

• Views and materialized views comparison
  In addition to table data, users can compare data in views and materialized views.
• Comparing data with different structures
  You can compare tables with different structures and columns with different data types. dbForge Data Compare delivers good capabilities to do such comparisons. This brings great relief and confidence for database professionals who have to keep their databases updated in a modern fast-paced environment.
• Comparing multiple schemas at once
  You can compare either one or several schemas at once. dbForge Data Compare provides a filter to quickly find required schemas in the list.
• Data comparison and synchronization via command line
  You can generate a command line arguments file and use it to compare and synchronize data in automatic mode via command line.
• Comparing large object data types
  Now you can synchronize data in LOB, BFILE and XML_TYPE columns quickly and easily.
• WHERE filter for data filtering
  You can quickly select only necessary data records to compare. This feature is useful when comparing tables or views with a huge number of data records.
• Generating comparison reports
  This will allow you to save and publish differences between databases to produce clear and accurate reports.
• Bi-directional data synchronization
  It takes only one click to change a synchronization direction. You do not have to recompare databases to synchronize both of them.
• Direct connection
  You can connect to your Oracle database without any Oracle client installed on your side. This will save you time and much effort.
• Extended data comparison and synchronization options
  You can better tune your comparison and synchronization as dbForge Data Compare 2.00 offers a wider choice of options. Now auto mapping, comparison, results display and synchronization options are at your disposal.
• Rollback synchronization on an error
  A transaction approach, used by dbForge Data Compare, ensures the integrity of databases in case any error occurs during synchronization. This makes each data synchronization safe and predictable.

About Devart

Devart (formerly known as Core Lab) is a leading company working in the database connectivity area. It offers well-known native VCL/CLX components and dbExpress drivers for direct access to Oracle, MS SQL Server and MySQL. The company provides advanced data access solutions for the Microsoft .NET Framework - ADO.NET data providers for native connectivity to Oracle, MySQL, and PostgreSQL database servers. Devart is also a vendor of powerful database tools designed to automate and simplify database development process.