Integrating the command line with applications
Published 13 December 2022
To integrate the SQL Data 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\SDC"
.
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\SDC"
.
The files should be installed in the same folder as your application.
For all SQL Data Compare functions:
- SQLDataCompare.exe
- SQLDataCompare.exe.config
- System.Threading.dll
For interfacing with SQL Source Control:
- RedGate.SOCCompareInterface.dll
For reading backups only:
- System.Data.SQLite.dll
- The x86 and x64 folders which contain architecture-specific versions of SQLite.Interop.dll