Integrating the command line with applications
Published 04 June 2013
To integrate the SQL Compare command line into an automated process within your environment, you must purchase a SQL Toolbelt license per developer to use DLM Automation on as many machines as you want. If you do not have a SQL Toolbelt 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 They can be found in the installation directory, which by default is in
"C:\Program Files (x86)\Red Gate\SQL Change Automation PowerShell\SC".
The files should be installed in the same folder as your application.
For all SQL Compare functions:
For interfacing with SQL Source Control:
For creating reports:
- the Reporting folder
For reading backups:
- The x86 and x64 folders which contain architecture-specific versions of SQLite.Interop.dll