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
To use the SQL Compare command line interface, you must have:
- A SQL Compare Professional Edition, SQL Developer Bundle, or SQL Toolbelt license
If you don't have a license, you can use the command line on a 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