Integrating the command line with applications
Published 13 December 2022
To integrate the SQL Compare command line into an automated process within your environment, you must purchase a Redgate Deploy license per developer to use SQL Change Automation on as many machines as you want. If you do not have a Redgate Deploy license, a trial will be created, which will expire after 28 days.
The files you need to bundle into your application installer are listed below, dependent upon if you still have the older DLM Automation V2 installed or have the later SQL Change Automation V3 (which replaced DLM Automation V2).
For DLM Automation V2, they can be found in the installation directory, which by default is in
"C:\Program Files (x86)\Red Gate\DLM Automation 2\SC".
For SQL Change Automation V3 or above, they can be found in the installation directory, which by default is in
"C:\Program Files (x86)\Red Gate\SQL Change Automation PowerShell\SC".
(if you have downloaded and installed the SQL Change Automation Powershell Module you can find the SQL Compare executable inside the installation directory inside the folder where Powershell modules are installed)
The files should be installed in the same folder as your application.