data compare

Devart Delivers Performance-Leading SQL Comparison Tool – dbForge Data Compare 2.00

Devart announced the release of a new version of the professional tool for SQL server data comparison and synchronization – dbForge Data Compare 2.00. Committed to support the needs of database-dealing professionals, Devart now delivers a performance-leading SQL comparison tool that incorporates three times faster data comparison and synchronization, the smallest price and greater satisfaction than all other data comparison tools offer.

Incorporating these three components, dbForge Data Compare 2.00 guarantees greater satisfaction and smother database-dealing experience for any SQL comparison and synchronization goals.

The highlights of dbForge Data Compare 2.00 include:


Synchronizing data between a company database and a data warehouse

Recently we’ve received a question from one of our customers asking how to synchronize data between companies servers and a data warehouse server. Let’s see how easy it can be done with the help of  dbForge Data Compare for SQL Server, a professional tool for data comparison and synchronization.

What we have:

We have two companies ( they use ERP software), each having their own SQL Server database with one table. The companies tables with their customers’ data are saved in the data warehouse as follows:

  • The SQL table for company1 is Company1$Customer.
  • The SQL table for company2 is Company2$Customer.

What we need:

We need to create a data warehouse with all information stored in one set of SQL tables. For example, the created data warehouse should contain a Customer table that contains all records of Company1$Customer and Company2$Customer.  This table should contain an extra field with a company name to make the records unique. We need to synchronize only changed records.

How to complete the task:


Data Comparison Methods Overview

Data comparison is a difficult and resource-intensive process. For convenience, this process can be divided into several steps.
First, you should compare tables from one database on one server with the database on the other server. You should choose columns for data comparison, and also choose a column that will be a comparison key.
The next step is to choose all data from these tables or some specified part of the data.
The third and the most important step is comparison of the two tables by the selected comparison key itself. During this process the status of each record is set to “only in source”, “only in target”, “different”, or “equal”.
The final steps of the data comparison process are including records to the synchronization and synchronization itself. During these steps records needed for synchronization are chosen, update script is created, and after that the script is executed.
You can read a detailed description of the comparison process here.

Now let’s look at the third step (data comparison) thoroughly.

There are several ways of data comparison that differ only by the side where data comparison is going to be performed – on the server side or on the client PC.


Automated MySQL data comparison and synchronization: how it works

In dbForge Studio for MySQL you can find Data Compare, a tool which allows you to compare and analyze tables data in databases, for example, to check that data in the synchronized databases are identical. Besides, it  allows synchronizing the data differences to get identical databases. The following picture illustrates comparison and synchronization of two MySQL databases.

Data Comparison Workflow

Data Comparison Workflow


Regular expressions to help in Finding and Replacing DML statements

Recently, we were updating our own database used for dbForge Data Compare for MySQL testing. I wanted to add several tables with data, using a dump file of one of the tables.

But how to drop a millisecond part in every pasted string, I mean a date like 2006-12-24 15:35:19.658′ should be replaced with ‘2006-12-24 15:35:19’ one?

Any simple Find and Replace functionality won’t help, as I don’t know what to find and with what to replace.





How to: Synchronize Data of a Big Database

Recently, one of our customers asked us how to synchronize large databases if the size of the generated synchronization script couldn’t be opened by dbForge Data Compare for SQL Server for editing. He tried to synchronize his large database, but the generated synchronization script (Table Data Update Script of all tables) was of a great size, so the program could not open it and recommended direct execution. However, the user wanted to review the script and edit it before execution.

Such cases are quite common, so here is the solution we recommend.
If you have a big database, synchronize it in three stages:


New product: dbForge Data Compare for SQL Server!


Devart Company has launched a new product line for working with SQL Server databases. Recently we have released a beta version of the first product in this dbForge for SQL Server product line – dbForge Data Compare for SQL Server. It is a tool for data comparison and synchronization.

Product’s key features

Nowadays there is a wide variety of data comparison and synchronization tools. It takes time and efforts to make a reasonable choice. We have analyzed a number of such products and found that Data Compare for SQL Server stands out against competitors thanks to a number of key features.

In this article, I am going to tell what exactly distinguishes Data Compare for SQL Server from dozens of similar tools. The key features list of Data Compare for SQL Server includes the following: