As seen in part 1 of this performance test, ApexSQL Diff 2012 starts off much faster than its competitor, and here as well, this trend continues. See below how ApexSQL Diff 2012 surpasses RedGate® SQL Compare 10
General tests
- Select all/deselect all comparison results
This metric provides an objective indication of how responsive the application appears to the user, by measuring the amount of time it takes for the GUI to respond to user commands Further code refinement in the latest version of ApexSQL Diff 2012, provides a clear advantage over the competitor. The test settings were the same as for the Results display test. Time was measured from clicking the “Check All” button until all the rows were checked. The same was done with “Uncheck all”, but in this case until all the rows were unchecked. “Check All” and “Uncheck all” scores were summed up for the final score
Live databases, backup to live database, script folder to live database, and source control to live database tests were performed by the same principles. As it will be visible from the results, ApexSQL Diff 2012 performance optimization led to a clear advantage in favor of ApexSQL Diff 2012 in each of the four aforementioned tests
The Complete comparison test involves the complete comparison process. It stars when the “Compare” button is clicked in the Project Settings form, up until all the results are populated in the main grid. The 100,000 object database was used and compared against itself, which resulted in 200,000 objects compared
The Complete synchronization test involves the complete synchronization process. It stars when the “Synchronize” button is clicked in the Main application window, up until the application asks for the generated file to be stored locally. The 100,000 object database was used and synchronized with an empty database, which resulted in 100,000 synchronized objects
- Live databases
- Backup to live database
- Script folder to live database
- Source control to live database
As it can be seen from the results, ApexSQL Diff 2012 surpassed this particular competitor in all tests
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
April 23, 2013
