ApexSQL Data Diff 2012 vs. RedGate® SQL Data Compare 10 performance comparison

Performance is a critical factor for our customers. Therefore we run performance tests as a part of our ongoing performance improvement efforts. Our SQL Server data comparison tool ApexSQL Data Diff 2012 was performance tested against RedGate® SQL Data Compare 10. The same tests were run with both applications in the same test environment

Performance testing and results

Performance tests were executed in the following areas:

  • Data comparison

    We have measured the time needed for data comparison in SQL databases with 100% identical structure and 100%, 90%, 50% and 10% identical data

  • HDD usage

    The size of the temporary folder created during the comparison process

  • Synchronization script creation time

    We have measured the time needed for creating the synchronization scripts

We’ve used 35 data types and their variants in 200 objects and over a 10 million records

Comparison time for this test was measured from the moment the comparison process began until the main grid was populated and all objects displayed. The average from three measurements of the time needed for comparison of two databases:

Data comparison time (seconds)

Test dataApexSQL Data DiffRedGate® SQL Data CompareFaster by
100% identical1,7693,37391%
90% identical1,5663,624131%
50% identical1,9494,293120%
10% identical2,2905,793153%

The temporary folder created during the comparison (MB)

Test dataApexSQL Data DiffRedGate® SQL Data CompareApexSQL Adventage
100% identical6,01110,47074%
90% identical6,61011,64876%
50% identical9,02815,21168%
10% identical11,39718,98167%

Synchronization script creation time (seconds)

Test dataApexSQL Data DiffRedGate® SQL Data CompareFaster by
90% identical19328146%
50% identical1,3011,93749%
10% identical2,5764,23164%

All tests were done on a local PC. No concurrent sessions or applications were running. SQL Server was installed on the local machine. Therefore, no network traffic affected the performance tests

System specification:

Windows 8 Pro x64
SQL Server 2012
CPU: Intel E8200
RAM: 6GB DDR2
HDD: 2TB ST2000DM001-9YN164 ATA
Database size: 8385 MB

Data types used are: Varchar, Varchar(MAX), int, BigInt, Binary, Bit, Char, DateTime, Decimal, Float, Money, NChar, NText, Numeric, NVarChar, Real, SmallDateTime, SmallInt, SmallMoney, SqlVariant, SysName, Text, TinyInt, UniqueIdentifier, VarBinary, Date, DateTime2, DateTimeOffset, Geography, Geometry, HierarchyId, Time, Xml, Image, Table and BLOB

Disclaimer: All product and company names are trademarks™ or registered® trademarks of their respective holders. ApexSQL is not affiliated, associated, authorized, endorsed by, or in any way officially connected with them or any of its subsidiaries or its affiliates

 

September 12, 2013