SQL Data Compare 15

Using the command line on a service account in Windows

Only applicable to version 15.3.14 and older. For more recent versions, see CI/CD pipelines

The SQL Data Compare command line can only be used in a Redgate Pipeline if it's licensed via Redgate Deploy or the SQL Toolbelt.  For more information, see our Product Specific Terms.

The SQL Data Compare command line interface can be used on a Windows service account to allow it to be used as part of an automated CI/CD process. In some cases, however, it is not possible to log in to a service account, which can prevent users from activating the CLI on these accounts.

To allow the CLI to be activated, the /allUsers flag can be used when activating the product via the command line. This will activate the product for all users, including service accounts. For example:

sqldatacompare /allUsers /activateSerial:123-456-789012-ABCD

This command requires you to be logged in using your Redgate ID. This can be done in two ways:

  • By launching the GUI and logging in there.
  • By following the link provided if you attempt to run the command when you are not logged in.

Further information about activation can be found here.


Didn't find what you were looking for?