SQL Compare 15

Using the command line

The command line 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 (see licensing requirements below)* 
  • perform scheduled comparisons and deployments of database schema
  • deploy to multiple databases

Requirements

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

  • A SQL Compare Professional Edition license, which is available in Flyway Enterprise, Redgate Deploy, SQL Toolbelt Essentials, or SQL Toolbelt. 
         * To use the command line within an automated change delivery process (e.g. as part of CI/CD processes), a Flyway Enterprise, Redgate Deploy, or SQL Toolbelt license is required.
    • If you don't have a license, you can try the free trial license for 14 days.
  • .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


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


Didn't find what you were looking for?