Using the command line
Published 21 August 2019
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#.
- 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
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