Devart Blog

large databases

Dare compare your data much more faster!

Posted by on May 11th, 2010

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.

Performance/Price

Performance/Price

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.

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

Posted by on April 29th, 2010

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:

(more…)

Data Comparison Methods Overview

Posted by on March 9th, 2010

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.

(more…)

dbForge Studio for MySQL v 3.60 – higher performance and new freedom in working with remote servers

Posted by on August 12th, 2009


Optimized tool facilitates database developers and web masters to efficiently work with remote databases at a lower cost with a greater speed.

Devart today announced the release of dbForge Studio for MySQL v 3.60, a cutting-edge tool for administration and development of MySQL databases.

The new upgrade is the contemporary answer for common bottlenecks originated from employing remote
MySQL Servers while developing, updating, and using modern large databases. dbForge Studio for MySQL v 3.60 offers new freedom for those who work with large schemas and data amounts especially in cases of using remote MySQL servers, for example serving web sites.

(more…)

What’s New in dbForge Schema Compare for SQL Server v1.10?

Posted by on June 5th, 2009

Devart has released today the improved version 1.10 of dbForge Schema Compare for SQL Server, a sophisticated tool specially designed to meet your specific comparison tasks, help analyze schema differences at a glance, and synchronize them correctly, saving time and efforts.

dbForge Schema Compare for SQL Server 1.10 features the following enhancements:

(more…)

How to: Synchronize Data of a Big Database

Posted by on June 5th, 2009

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:

(more…)

Coming Soon: dbForge Schema Compare for SQL Server v1.10

Posted by on May 27th, 2009

After analyzing our users’ feedback on the first release of dbForge Schema Compare for SQL Server. We decided to change our roadmap for this product and to release version 1.1 of the product before adding new major features.

So what new features will this version include?

(more…)

Synchronization script is too large – what shall I do?

Posted by on May 19th, 2009

In my previous post Schema Comparison Stress Testing I mentioned problems we met testing dbForge Schema Compare for SQL Server on large database. In this post I would like to give you some tips on processing large synchronization scripts.

Problem Description

Suppose you have compared two databases and want to synchronize them.  You tried to generate the synchronization script but it’s about 100 Mb and simply couldn’t be stored in the memory. When you open it in SQL editor for execution, the application fails with ‘Out Of Memory’ error.

Solution

There are two solutions for this problem:

(more…)