Configuring Interactive SQL to use source control

You must configure Interactive SQL to use source control before you can perform source control actions on files, such as checking files in and out, comparing different versions of a file, and viewing the history for a file.

If you are running Interactive SQL on a Windows computer that has a source control product that supports the Microsoft SCC API, you can use that product or use a custom (command line oriented) system.

Configuring SCC source control systems
To configure Interactive SQL source control on Windows with SCC
  1. Click Tools » Options.

  2. In the left pane, click Source Control.

  3. Click Enable Source Control Integration.

  4. Click OK.

Configuring other source control systems
To configure Interactive SQL source control systems with a command line interface
  1. Click Tools » Options.

  2. In the left pane, click Source Control.

  3. Click Enable Source Control Integration.

  4. Click Configure.

  5. In the Custom Source Control Options window, click Reset.

  6. Select your source control system from the list, and then click OK.

  7. Edit the commands in the list as necessary by selecting an action from the Source Control Actions list, and then typing the corresponding command in the Command Line pane.

    When you are defining commands for your system in the Source Control Actions list, use the placeholder [FILENAME] to represent the name of the file that is used when you run the command. For example, the command to submit a file in Perforce is p4 submit [FILENAME]. Actions that appear bold in this list have commands defined for them, while actions in plain font do not have a command defined.

    The Custom Source Control Options window showing defined commands in bold.

    If you do not specify a command line for an action, the item in the File » Source Control menu is disabled.

    Tip

    You can export your source control command lines to an external file by clicking Export in the Custom Source Control Options window (accessed by choosing Tools » Options, and then clicking Configure on the Source Control pane). You can later read these commands back in by clicking Import in this window. This may be useful if you need to configure Interactive SQL source control command lines on several computers.

  8. Click OK, and then click OK again.