SQL Data Compare 15

Getting started with the SQL Data Compare command line

The command line interface provides access to the functionality of SQL Data Compare. For example, using the command line interface you can:

  • automate the comparison and deployment of database schema
  • perform scheduled comparisons and deployments
  • deploy multiple databases

You invoke the command line either from a script, such as a batch script or VBScript, or by using the facilities provided by compiled languages such as VB, C++ and C#.

Prerequisites

To use the SQL Data Compare command line interface, you must have:

  • A SQL Data Compare Professional Edition license, which is available in Flyway Enterprise, Redgate Deploy, SQL Toolbelt Essentials, or SQL Toolbelt. 
    If you do not have a license, you can use the command line for 14 days.
  • To use the command line within an automated change delivery process, a Flyway Enterprise, Redgate Deploy or SQL Toolbelt license is required.
  • .NET framework version 2.0 or later. 
    This is required to run the command line interface, but it is not required when you develop applications and scripts that use the command line interface.
  • MDAC 2.8 or later.

Didn't find what you were looking for?