The comparison options configure how SQL Source Control deploys changes and how it compares the database with the version in source control. For example, you can have SQL Source Control ignore differences in comments or white space.

After you change the comparison options, they only affect your machine. You can commit the changes to source control to share them with your team.

Changing the comparison options

  1. In the Object Explorer, select the database you want to set the options for.
  2. In SQL Source Control, in the Setup tab, under Options just for this database, click Comparison options.

  3. Set the comparison options you want to use for the database and click Save.

    For more information about what the options do, see Options used in the command line in the SQL Compare documentation.

    The options are saved for the database.

Default options

By default, the following options are enabled:

Sharing the comparison option changes with your team

After you save changes to the comparison options, the options are only saved on your machine.

To share the options:

  1. Go to the Commit changes tab.
    The change is shown waiting to be committed:

  2. Make sure the options change is selected, and click Commit.

Your change is committed. Other people on your team can get your option changes in the Get latest tab. This makes sure everyone works with the same options.