Microsoft SQL Server Compare Tools

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

Wikimedia Foundation. 2010.

Игры ⚽ Нужна курсовая?

Look at other dictionaries:

  • Microsoft SQL Server — Developer(s) Microsoft Stable release SQL Server 2008 R2 (10.50.2500.0 Service Pack 1) / July 11, 2011; 4 months ago …   Wikipedia

  • Microsoft SQL Server — Entwickler Microsoft Aktuelle Version SQL Server 2008 R2 (10.50.2500.0 Service Pa …   Deutsch Wikipedia

  • SQL Server Express — Microsoft SQL Server Express, a freely downloadable and distributable version of Microsoft s SQL Server relational database management system, comprises a database specifically targeted for embedded and smaller scale applications. Contents 1… …   Wikipedia

  • Microsoft Visual Studio Express — Developer(s) Microsoft Stable release 2010  …   Wikipedia

  • Microsoft SharePoint — 2010 Microsoft SharePoint 2010 Web interface Develope …   Wikipedia

  • Microsoft Dynamics GP — is a mid market business accounting software or ERP Software package marketed in North and South America, UK and Ireland, the Middle East, Singapore, Australia and New Zealand. It is used in many additional countries with partner supported… …   Wikipedia

  • Microsoft Expression Studio — Microsoft Expression Developer(s) Microsoft Stable release 4.0 / June 7, 2010; 16 months ago ( …   Wikipedia

  • Microsoft Office 2010 — applications shown on Windows 7 (clockwise from top left: Word, Excel, OneNote, PowerPoint; t …   Wikipedia

  • Microsoft Expression Web — Expression Web 4 running on Windows 7 …   Wikipedia

  • Microsoft Visual Studio Express — Тип IDE Разработчик Microsoft Лицензия Microsoft EULA Сайт http://msdn.microsoft.com/vstudio/express/default.aspx, http://www.microsoft.com/expre …   Википедия

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”