SQL Compare 14

Using the command line

The command line interface provides access to the functionality of SQL Compare. For example, when licensed appropriately you can use the command line interface to:

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

You can 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#.

Requirements

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

  • A SQL Compare Professional Edition license, which is available in Redgate Deploy, SQL Toolbelt Essentials, or SQL Toolbelt. 
  • If you don't have a license, you can use the command line on a trial license for 14 days.
  • To use the command line within an automated change delivery process, a 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 isn't 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?