ApexSQL Diff 2015 R3 vs RedGate® SQL Compare 11.2.1 comparative performance test of live databases and backups

As part of our continuous efforts to measure and improve our software performance, we have performance tested ApexSQL Diff 2015 R3 vs RedGate® SQL Compare 11.2.1.

Each test was performed three times, and the average was used as the final result. All measurement results are displayed in seconds:

Live database performance (s)

RedGate® SQL Compare 11.2.1ApexSQL Diff 2015 R3Faster byObject countTest database description
7.04.267%358A database created specifically for ApexSQL Diff testing (not only performance). Contains objects of different types with different characteristics (such as table with name “TestCase011 – Òåñòîâàÿ Òàáëèöà”, encrypted views, objects for different schemas and so on)
6.84.454%1,000A standard Microsoft-shipped database. Contains different objects with relations and types. Included in test more specifically to backups performance testing because backup is compressed
5.13.259%1,000A standard Microsoft-shipped database for SQL Server 2012. Contains different objects with relations and types
5.13.354%1,000A standard Microsoft-shipped database for SQL Server 2008. Contains different objects with relations and types
98.753.584%2,000Production database. Contains different objects of different types and structure
9.58.610%5,500Production database. Contains different objects of different types and structure
12.313.4-8%20,000A special database that has been created for testing of performance of ApexSQL Diff/ApexSQL Data Diff. Contains 20,000 objects (1,000 objects x 20 types)
2,104.793.32155%100,000A special database that has been created for testing of performance of ApexSQL Diff/ApexSQL Data Diff. Contains 100,000 objects (5,000 objects x 20 types)
8.16.035%10,000A special database that has been created for testing of performance of ApexSQL Diff/ApexSQL Data Diff. Contains 10,000 schemas
50.025.894%44,000Production database. Contains different objects of different types and structure
8.15.256%3,500Production database. Contains different objects of different types and structure
7.33.987%553A database created specifically for ApexSQL Diff testing (not only performance). Contains objects of different types with different characteristics (such as table with name “far”m”, encrypted stored procedures, stored procedure with name “pcTestC~ase006” and so on
37.962.5-64%2,000A database that looks like real TFS database. Contains different objects of different types and structure

 

Backup performance (s)

RedGate® SQL Compare 11.2.1ApexSQL Diff 2015 R3Faster byObject countTest database description
6.55.323%358A database created specifically for ApexSQL Diff testing (not only performance). Contains objects of different types with different characteristics (such as table with name “TestCase011 – Òåñòîâàÿ Òàáëèöà”, encrypted views, objects for different schemas and so on)
51.36.1740%1,000A standard Microsoft-shipped database. Contains different objects with relations and types. Included in test more specifically to backups performance testing because backup is compressed
8.559.0-5%1,000A standard Microsoft-shipped database for SQL Server 2012. Contains different objects with relations and types
7.63.6111%1,000A standard Microsoft-shipped database for SQL Server 2008. Contains different objects with relations and types
487.9280.3174%2,000Production database. Contains different objects of different types and structure
16.312.629%5,500Production database. Contains different objects of different types and structure
36.526.339%20,000A special database that has been created for testing of performance of ApexSQL Diff/ApexSQL Data Diff. Contains 20,000 objects (1,000 objects x 20 types)
3,706.8302.81124%100,000A special database that has been created for testing of performance of ApexSQL Diff/ApexSQL Data Diff. Contains 100,000 objects (5,000 objects x 20 types)
19.66.9184%10,000A special database that has been created for testing of performance of ApexSQL Diff/ApexSQL Data Diff. Contains 10,000 schemas
141.388.260%44,000Production database. Contains different objects of different types and structure
19.415.227%3,500Production database. Contains different objects of different types and structure
5.04.84%553A database created specifically for ApexSQL Diff testing (not only performance). Contains objects of different types with different characteristics (such as table with name “far”m”, encrypted stored procedures, stored procedure with name “pcTestC~ase006” and so on
25.620.227%2,000A database that looks like real TFS database. Contains different objects of different types and structure

 

The date of the test was: 10/7/2015

Test configuration was:

Windows 8.1 x64
CPU: AMD Phenom™ II X4 965 3.40 GHz
RAM: 8GB
SQL Server version: 2014

If you have a schema you would like to have us test on please send it to us.

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


October 8, 2015