$595

($744 including support & upgrades)

  • Download 14-day free trial
  • Create a quote for SQL Comparison SDK
  • Add SQL Comparison SDK to shopping cart
SQL Comparison SDK box shot

SQL Comparison SDK™

Walk-through: Using Red Gate APIs

This walk-through will show you:

  • Using the SQL Compare API to automate comparison and synchronization tasks
  • Features in the SQL Comparison SDK
  • Building your application
Stop walk-through

Step 1: Setting up a new project

Setting up a new project

The SQL Comparison SDK allows you to automate the comparison and synchronization of database schemas and data by using the engines behind SQL Compare, SQL Data Compare, and SQL Packager. This walk-through is a very basic example of how SQL Compare's functionality can be automated, using the SQL Compare API.

The first thing you need to do is create a new project. We are going to create a Console Application. However, you could use the SQL Comparison SDK from within a Windows Form application, an ASP.NET application, or any other .NET application. Our console application is going to synchronize the structure of two databases, WidgetProduction and WidgetStaging, by automating the SQL Compare engine. We will be using C#, but you could choose to use Visual Basic.NET or any other .NET language.