- Microsoft SQL Server Compare Tools
-
This is a list of notable Microsoft SQL Server Compare Tools that are used to compare the schemas and/or data of differing Microsoft SQL Server databases.
Contents
General information
The following tools are available as Freeware.
Tool Maintainer First public release date Latest stable release BucketSoft Data Comparisons Express BucketSoft 2009-04 0.97 CoderTools Schema Compare CoderTools 2009-01-31 1.0.0 Data Inspector / Schema Inspector Atlantis Interactive UK Ltd. 2010-01-17 2.1.23 / 2.1.18 Free Database Compare Starinix 2008-01-01 2.0 SQL Server Compare Yes Soft 2006-05-31 2.2 (2006-01-20) sql-dbdiff Spiked Software 2010-02-21 0.4 (2010-04-16) MSSQL.SchemaDiff WinTestGear 2010-07-21 1.05 (2010-08-03) sp_CompareDB Get the code/tool from this forum thread post by Shastryv
Viktor Gorodnichenko? May 24, 2001 06/25/2003? DBComparer DBComparer Inc 2009-04-24 3.0 OpenDBDiff The following tools are not free software, but most of them have trial versions available, some with "lite" features.
Tool Maintainer First Public Release Date Latest stable release Free/lite version available? AdeptSQL Diff RaysLab ? 2010.09 Yes ApexSQL Data Diff ApexSQL 2008.01 2010.01 No ApexSQL Diff ApexSQL 1.2.11 2011.01.0262 No CompareData Zidsoft 2004-12-29 1.6.5.132 (2011-11-17) Yes Database Compare Nob Hill Software 2006-06 1.6 Yes D-Softs Database Comparer Database Comparer Ltd 2009-06-15 2.2 No DB Ghost Schema Compare Innovartis 2002-02-23 5.0.1311 No Datanamic SchemaDiff for MS SQL Datanamic ? 2011.01 No dbForge Data Compare Devart 2009-02-02 3.0 Yes, if you qualify dbForge Schema Compare Devart 2009-03-25 2.0 Yes, if you qualify Gemini Delta - SQL Difference Manager for .NET Gemini Software Solutions, LLP 2011-05-12 1.6 No Embarcadero Change Manager Embarcadero Technologies ? 4.0 No EMS DB Comparer for SQL Server EMS Database Management Solutions ? 2.2.0.1 No MS SQL Data Sync SQL Maestro Group October 12, 2011 11.10 No MS SQL Server Compare Two Tables Software Sobolsoft ? 7.0 No Nob Hill Database Compare Nob Hill software ? 1.3.01 No SQL Compare Red Gate Software 1999 9.0 No SQL Data Compare Red Gate Software 2000 9.0 No SQL Delta The Australian Software Company ? 4.1 No SQL Examiner Suite TulaSoft 2005 4.0 No Teratrax Database Compare Teratrax ? 2.0.3 Yes Visual Studio Team System Database Edition Microsoft ? ? tablediff (part of SQL Server 2005) Microsoft ? ? Yes? xSQL Object xSQL Software ? 2.5.1.7 Yes Cross-Database Comparator Pro DBBALANCE 2006-02-10 7.0 No SQL Accord SQL Effects Software May 2005 1.3.6 Yes SQLDBDiff SQLDBTools ? 3.5 Yes Features
This section lists the features of available products.
Compare
Tool Maintainer Table/View Query Stored Procedure/Function Data Data (where clause) Columns Primary Keys Index Foreign Key Exported Foreign Key Permission Trigger Data Text Parameters ApexSQL Data Diff / ApexSQL Diff ApexSQL LLC Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Gemini Delta - SQL Difference Manager for .NET Gemini Software Solutions, LLP No No Yes Yes Yes No No Yes Yes Yes Yes Yes CompareData Zidsoft Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Cross-Database Comparator Pro DBBalance Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes No D-Softs Database Compare 【D-Softs】 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes dbForge Schema Compare for SQL Server Devart N/A N/A Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes dbForge Data Compare for SQL Server Devart Yes Yes N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A DB Ghost Innovartis Ltd Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes MS SQL Data Sync SQL Maestro Group Yes Yes N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A SQL Compare / SQL Data Compare Red Gate Software Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Data Inspector / Schema Inspector Atlantis Interactive UK Ltd. Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes SQL Examiner / SQL Data Examiner TulaSoft Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Generate Sync Script
Tool Maintainer Table/View Query Stored Procedure/Function Data Columns Primary Keys Index Foreign Key Permission Trigger Data ApexSQL Data Diff / ApexSQL Diff ApexSQL LLC Yes Yes Yes Yes Yes Yes Yes Yes Yes CompareData Zidsoft Yes No No No No No No No No Cross-Database Comparator Pro DBBalance Yes Yes Yes Yes Yes No Yes Yes Yes D-Softs Database Compare D-Softs Yes Yes Yes Yes Yes Yes Yes Yes Yes dbForge Schema Compare for SQL Server Devart N/A Yes Yes Yes Yes Yes Yes N/A Yes dbForge Data Compare for SQL Server Devart Yes N/A N/A N/A N/A N/A N/A Yes N/A DB Ghost Innovartis Ltd Yes Yes Yes Yes Yes Yes Yes Yes Yes MS SQL Data Sync SQL Maestro Group Yes N/A N/A N/A N/A N/A N/A Yes N/A SQL Compare / SQL Data Compare Red Gate Software Yes Yes Yes Yes Yes Yes Yes Yes Yes Data Inspector / Schema Inspector Atlantis Interactive UK Ltd. Yes Yes Yes Yes Yes Yes Yes Yes Yes SQL Examiner / SQL Data Examiner TulaSoft Yes Yes Yes Yes Yes Yes Yes Yes Yes Synchronize
Tool Maintainer Table/View Query Stored Procedure/Function Data Columns Primary Keys Index Foreign Key Permission Trigger Data ApexSQL Data Diff / ApexSQL Diff ApexSQL LLC Yes Yes Yes Yes Yes Yes Yes Yes Yes CompareData Zidsoft Yes No No No No No No No No Cross-Database Comparator Pro DBBalance Yes Yes Yes Yes Yes No Yes Yes Yes D-Softs Database Compare D-Softs Yes Yes Yes Yes Yes Yes Yes Yes Yes dbForge Schema Compare for SQL Server Devart N/A Yes Yes Yes Yes Yes Yes N/A Yes dbForge Data Compare for SQL Server Devart Yes N/A N/A N/A N/A N/A N/A No N/A DB Ghost Innovartis Ltd Yes Yes Yes Yes Yes Yes Yes Yes Yes MS SQL Data Sync SQL Maestro Group Yes N/A N/A N/A N/A N/A N/A No N/A SQL Compare / SQL Data Compare Red Gate Software Yes Yes Yes Yes Yes Yes Yes Yes Yes Data Inspector / Schema Inspector Atlantis Interactive UK Ltd. Yes Yes Yes Yes Yes Yes Yes Yes Yes SQL Examiner / SQL Data Examiner TulaSoft Yes Yes Yes Yes Yes Yes Yes Yes Yes Performance
This section contains performance charts for comparison/synchronization tools.
Data Comparison & Synchronization
The Adventure Works 2008R2 SR1 demobase was used for tests. It takes 185 Mb on hard disk and has 761 thousand rows in all tables of various data types.
Test #1: Compare the database with itself and measure "Comparison Time" - how fast data comparison engine compares data.
Test #2: Compare the database with similar but empty one - how fast a tool stores different rows on a disk. The time taken is "Caching time", and size of all temporary files is "Cache size". Some tools have "Compress temporary data cache" option which writes compressed data on a disk.
Test #3: Generate synchronization script after test #2 - how fast a tool generates an output file and how big it is.
Test #4: Execute generated script via a tool - check if script is valid, how optimum it is, and how fast a tool generates and sends query batches.
Tool Maintainer Version Comparison Time Caching time Caching time (compressed)
Cache size Cache size (compressed)
Sync. script generation time
Output file size Script execution time
ApexSQL Data Diff ApexSQL 2010.01.0016 29 sec 16 sec N/A ? N/A 12 sec 215 Mb (UTF-16 only) 2 min 34 sec dbForge Data Compare Devart 2.0.159 8 sec N/A 5 sec N/A 24 Mb 20 sec 224 Mb (UTF-8) 2 min 12 sec SQL Data Compare Red Gate Software 9.0.0.117 10 sec 6 sec 12 sec 125 Mb 36 Mb 21 sec 245 Mb (UTF-8) 2 min 27 sec SQL Data Examiner TulaSoft 4.0.0.120 10.5 sec 6.5 sec N/A 135 Mb N/A 18 sec 239 Mb (UTF-8) 6 min 56 sec failed at 99.9%
xSQL Data Compare xSQL Software 4.0.0.0 22 sec 16 sec N/A ? N/A 17 sec 232 Mb (ANSI only!) 6 min 39 sec SQL Delta The Australian Software Company
5.1.0.9 55 sec 57 sec N/A 230 Mb N/A 2 min 10 sec 448 Mb (UTF-16 only) 3 min Test configuration:
- Intel i7-2630QM (4 cores @ 2GHz, 8 threads)
- 12 Gb RAM DDR3 @ 1333 MHz (9-9-9-24)
- Intel SSD X25-M 120 Gb
- Microsoft SQL Server 2008 R2 Developer Edition 64-bit
- Windows 7 Ultimate x64
Licensing
This section lists the licensing options of available products.
Tool Maintainer License Price Free version Technical support Free updates Evaluation period Money-back guarantee ApexSQL Data Diff ApexSQL Yes $ 579 to 399$ Free Trial version Yes With Software Assurance 14 days No ApexSQL Diff ApexSQL Yes $ 579 to 399$ Free Trial version Yes With Software Assurance 14 days No CompareData Zidsoft Yes $395 Yes Yes 3 years 30 days No Cross-Database Comparator Pro DBBalance Yes $499 to $324 Free Trial Version Yes 1 year 14 + days ? dbForge Schema Compare for SQL Server Devart Yes $230 to $115 Free Trial Version Yes 1 year 30 days Yes dbForge Data Compare for SQL Server Devart Yes $230 to $115 Free Trial Version Yes 1 year 30 days Yes DB Ghost Innovartis Ltd Yes $440 to $189 ? Yes ? ? ? MS SQL Data Sync SQL Maestro Group Yes $129 to $69 Free Trial Version Yes 1-3 years 15 days No SQL Compare Red Gate Software Yes $595 to $227 Free Trial Version Yes With Support and Upgrades 14 days Yes SQL Data Compare Red Gate Software Yes $595 to $227 Free Trial Version Yes With Support and Upgrades 14 days Yes Categories:- Microsoft server technology
Wikimedia Foundation. 2010.
