Using the command line
Published 13 December 2022
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#.
- Command line basics
- Integrating the command line with applications
- Simple examples using the command line
- Using XML to specify command line arguments
- Example - selecting single tables for comparison
- Example - selecting tables with unrelated names
- Switches used in the command line
- Options used in the command line
- Exit codes used in the command line
- Using the command line on Linux
- Using the command line on a service account in Windows