data compare

Reinvented dbForge Tools for MySQL Have Arrived!

After a grand update of dbForge Studio for MySQL, we haven’t forgotten about the rest of the dbForge for MySQL product range. Our developers took maximum care of each and every MySQL tool and revamped them with specific new features and updates. (more…)

How to Compare Multiple Databases through Command Line

Very often, there is a need to compare or synchronize data between two databases on the same server. To detect differences, you can simply use dbForge Data Compare for PostgreSQL, which allows you to perform this process with a few clicks. (more…)

Devart to Start New Product Line for PostgreSQL

Devart is glad to announce the release of dbForge Data Compare for PostgreSQL — a powerful and easy-to-use tool for table data comparison and synchronization. This tool allows you to review all the differences in compared tables and execute an automatically generated script to remove these differences. Customizable comparison and synchronization process allows you to select tables and fields for comparison and adjust many comparison options. User friendly wizard, guides you through the data comparison and synchronization process step by step. A possibility of using Windows Task Scheduler enables you to automate database synchronization process. (more…)

Loading Oracle LOB Data – Code Samples

Recently we were working over the release of the version 2.0 of  dbForge Data Compare for Oracle. One of the main features added to the new version was synchronization of the LOB data. When we developed the first release of the product we postponed this feature because of challenges of synchronizing LOB data. These challenges caused by nature of data stored in BLOB or CLOB columns. It’s large and simply does not fit into SQL script. But we’ve found the solution.

In this article we will examine basic methods of loading LOB data into a table.


Oracle DBMS_COMPARISON package overview

During replicating data in one or another way, it happens that synchronized objects may differ. This situation may take place in the following cases:

  • If changes made in one of copied databases were not captured
  • The changes were captured but not forwarded
  • The changed were forwarded but not applied due to some reasons

It should be admitted that full or partial synchronization may be required due to some other reasons, not related to replication. But the question is how to synchronize database objects?

10 Ways to Synchronize Oracle Table Data

In the process of developing databases many developers and testers encounter a problem of synchronizing data between local and remote Oracle database. Changes made in a local database must be reflected in a remote database. It’s also necessary to check test results with the model database, to find non-synchronized tables that appeared after these tests, to have possibility to return the test database to its initial state when testing newly developed versions of databases intensively. Another problem may be to create CRUD operations quickly without making too much effort to find different objects and to write DML statements. Now let’s find out how one can synchronize data of Oracle databases.

Simple solutions:

Devart Unveils Free Data Compare Tool for Oracle to Bring High Speed and Adjustable Comparison

Devart today unveiled a new data comparison tool, dbForge Data Compare for Oracle. It delivers automatic data comparison in Oracle databases, provides a convenient GUI to manage the differences, and generates SQL*Plus-compatible synchronization script to synchronize the data.

Read more: dbForge Data Compare for Oracle news…

How To: Kill User Sessions in Oracle

Not a long time ago we started to write auto-tests for testing our new product –
dbForge Data Compare for Oracle. To recreate a schema in Oracle all user sessions should be killed.

To achieve this we’ve written the following PL/SQL script:


dbForge Data Compare for Oracle: new life to the product line

Recently our development efforts were focused on dbForge for SQL Server product line. We’ve made five major releases of SQL Server database tools in last 18 months. Besides, we’ve made two major releases of MySQL database tools in this period. Our Oracle database tools product line, once actively developed, was frozen for almost three years. Sure we made maintenance releases, but no new features and tools. Our Oracle tools even were not re-branded to dbForge for Oracle. But now we decided to breeze the new life into Oracle tools development.

The first tool in the dbForge for Oracle product line will be Data Compare. For the first release we decided to make a free tool with basic functionality:


Dare compare your data much more faster!

We compared some best-of-breed data comparison tools with dbForge Data Compare to find out which one is faster to compare and synchronize data in SQL Server databases.

The participant tools were tested with default settings on live databases on SQL Server 2008 that installed with default settings on a desktop (with a dual-core processor and 2Gb of RAM). Both the SQL Server and the SQL tools were installed on the same desktop.

Live Databases:
Two databases with total size of 1Gb: 115 tables containing one with 3 million records of numeric and string data types, the other with middle size BLOB data.

Task №1: We measured the speed of each tool while comparing the data, generating an update script, and at last synchronizing the databases.

Data Comparison/Synchronization Performance

Data Comparison/Synchronization Performance

Result №1: Tests results show that dbForge Data Compare for SQL Server v2.00 has leaved the competitors far behind.

Task №2: We decided to compare the performance of the selected participant tools based on the main industry-leading competitor’ performance. Besides we took into account the product price and tried to calculate the efficiency as best performance for less money.



Result №2: This graph shows that not all the tools can be proud of delivering an expected combination of best performance and best price. dbForge Data Compare handles this task well.

Check Shot

To fully complete our research, we decided to go the whole hog and use the aforementioned tools to compare large databases with the size of 120Gb (some tables in these databases have 2.4 billion records, some tables contain 1.5Gb of LOB data, the FILESTREAM table is with 5.3Gb of records). dbForge Data Compare was good at comparison, while neither of the competitive tools compared tables with LOB data and records in the FILESTREAM table. When we excluded such tables, only one tool coped with 2.4 billion records.
Speed rate of dbForge Data Compare is several times higher than other popular competitive tools have.

Try dbForge Data Compare on your database. Delivering qualitative data comparison and synchronization is our fame.

We guarantee quick support and product improvement if dbForge Data Compare fails to compare and synchronize your database. We even may give you the product license for free.

Moreover, you can take full advantage of data comparison and synchronization functionality in dbForge Compare Bundle that includes both dbForge Data Compare for SQL Server and dbForge Schema Compare for SQL Server, and also allows you to save money as compared to buying the tools separately.

We compared some best-of-breed comparison tools with dbForge Data Compare 2.00 to find out which one is speedier to compare and synchronize data in SQL Server databases.

The participant tools were tested with default settings on live databases on SQL Server 2008 that installed with default settings on a desktop with a dual-core processor and 2Gb of RAM. Both the SQL Server and the tools were installed on the same desktop.