Red Gate logo

Automate comparison and synchronization tasks

Compare and synchronize automatically database schemas and data

Download 14-day free trial

An introduction to SQL Comparison SDK

The SQL Comparison SDK provides a means to compare and synchronize database schemas and data from within your own applications, with a greater degree of control than the command line interfaces:

  • Schedule database comparison and synchronization
  • Migrate and deploy schema and data changes
  • Build comparison and synchronization functionality into your own applications
  • Automate tasks using the new Sequence object type, File Tables, and Columnstore Indexes in SQL Server 2012

$895

per user

Buy now

API access and distributing the SDK

Access to APIs

The SQL Comparison SDK gives you access to the APIs used within our SQL Server database comparison and synchronization tools.

By accessing these, you can completely automate all your SQL Server comparison, synchronization, packaging, and update jobs.

You can, for example, create a program to schedule the comparison and synchronization of your SQL databases; then automate their installation, replication and verification.

Distributing the SDK

If you include the SQL Comparison SDK as part of your applications, you can distribute up to 10 copies as part of your license.

For more than 10 distributions there will be an additional charge per distribution.

If you would like further information on distributing the SQL Comparison SDK please give us a call on, 0800 169 7433.

Learn more about the SQL Comparison SDK

Case Study

Leggett & Platt reinvents its data migration process with help from Red Gate's SQL Comparison SDK

Leggett & Platt has approximately 20 SQL Servers, each hosting around five databases, to handle the data its international facilities team use to run their day-to-day business. Updating these databases across each location used to be a daunting task as SQL statements had to be created manually.

Leggett & Platt wanted to reduce the chance of error as well as ensure the .NET application they created for each database could be executed by someone at each branch, even those with limited SQL experience.

Read the case study (PDF)

Technical paper

Synchronizing SQL Server databases using SQL Comparison SDK

A common problem, that I have been asked to solve by a number of clients, is moving data and database structure changes from a database located on the customer's intranet up to the database server on the Internet...The SQL Comparison SDK enables you to do things that are just not possible using any other tool I can think of.

Read the technical paper (PDF)

What our customers are saying

Technical requirements

The SQL Comparison SDK is a package of APIs you can use in any IDE designed for .NET development. Using the SDK requires programming experience.

If you want to automate database changes without writing code, you can use the command line interfaces to SQL Compare Pro and SQL Data Compare Pro.

  • Windows Vista, Windows 7, Windows 8, Windows Server 2003, or Windows Server 2008
  • SQL Server client-side tools
  • SQL Server 2005, 2008 or 2008 R2, SQL Server 2012, Amazon RDS, and SQL Azure
  • Microsoft .NET Framework 2.0 or later
  • MDAC 2.8
  • 128 MB RAM
  • 200 MB hard disk space
  • Runs on a user's PC (can also run on a server)
  • Visual Studio, or similar development environment that uses the .NET Framework, if using APIs

If you have any questions regarding the technical specifications, please contact us.