When you activate the SQL Automation Pack, the following command line tools are activated:

• SQL Compare (SQLCompare.exe)
• SQL Data Compare (SQLDataCompare.exe)
• SQL Packager (SQLPackager.exe)
• SQL Doc (SQLDoc.exe)
• SQL Data Generator (SQLDataGenerator.exe)
• Schema Compare for Oracle (SCO.exe)
• Data Compare for Oracle (DCO.exe)
• sqlCI.exe

How you activate the SQL Automation Pack license depends on the automation tool you're using:

Using sqlCI.exe

To activate the SQL Automation Pack in v1.1.1.2102 and later:

To activate the SQL Automation Pack in v1.1.0.7 to v1.1.1.1981:

1. Open a command prompt, and navigate to the folder where sqlCI.exe is located. By default, this is:
   C:\Program Files (x86)\Red Gate\SQL Automation Pack 1\sqlCI

2. Run the build step, including the /licenseSerialKey option with your serial number. For example:

   Build /scriptsFolder=WidgetShop\Database\Scriptsfolder /packageId=WidgetShop /packageVersion=1.0 /temporaryDatabaseServer=(localdb)\v11.0 /licenseSerialKey=123-456-789012-ABCD

To activate the SQL Automation Pack in v1.0.4.2 and earlier:

1. Open a command prompt, and navigate to the folder where sqlCI.exe is located. By default, this is:
   C:\Program Files (x86)\Red Gate\SQL Automation Pack 1\sqlCI

2. Run the /licenseSerialKey command with your serial number. For example:

   sqlCI /licenseSerialKey=123-456-789012-ABCD

Using the TeamCity plugin

To activate the SQL Automation Pack using the TeamCity plugin:

1. In TeamCity, go to the configuration page for the Red Gate SQL CI Build step.
2. At the top of the page next to the Help link, click Enter serial number.
   The Red Gate Licensing page is shown.
3. Under Enter your Automation License serial number, in the Serial box, enter your serial number.
4. Click Save.

The SQL Automation Pack is activated the next time the build runs.

Using the TFS Build plugin

Using the TFS MSBuild scripts

To activate the SQL Automation Pack In 1.1.0.1765 and later:

1. In the SQL Automation Pack installation directory, open the SQLCI-steps folder. By default, this is:
   C:\Program Files (x86)\Red Gate\SQL Automation Pack 1\tfs-scripts\SQLCI-steps

2. Open sqlCI.global.properties in a text editor.
3. For the <licenseSerialKey> element, enter your serial number.
4. Save the file.

The SQL Automation Pack is activated the next time the build runs.

To activate the SQL Automation Pack v1.1.0.7 and earlier:

1. In the SQL Automation Pack installation directory, open the sqlCI folder. By default, this is:

   C:\Program Files (x86)\Red Gate\SQL Automation Pack 1\sqlCI

2. Open sqlCI.targets in a text editor.
3. Under Automation license serial number, in the <activateSerial> element, enter your serial number.
4. Save the file.

The SQL Automation Pack is activated the next time the build runs.

Using the NAnt build script

To activate the SQL Automation Pack using the NAnt build script in SQL Automation Pack 10.4.2 and earlier:

1. In the SQL Automation Pack installation directory, open the sqlCI folder. By default, this is:
   C:\Program Files (x86)\Red Gate\SQL Automation Pack 1\sqlCI
2. Open sqlCI.build in a text editor.
3. Under Automation license serial number, in the value attribute, enter your serial number.
4. Save the file.

The SQL Automation Pack is activated the next time the build runs.