These pages cover SQL Source Control 3. Documentation for older versions is also available.

Skip to end of metadata
Go to start of metadata

SQL Source Control uses the SQL Compare engine to compare databases. For more information, see the How SQL Source Control works behind the scenes.

The default SQL Source Control options work well for most situations. However, your particular database or working practices may require you to change some SQL Source Control engine options. 

To do this:

  1. In the Object Explorer on the left, select the database you want to set the options for.
  2. In SQL Source Control, in the Setup tab, right-click the Linked to database path, and select Edit Comparison Options.

    The Edit Database Compare Options dialog opens:

  3. To turn on the SQL Compare engine options you want to use, set them to True. To turn them off, set them to False.

    For more information about the options, see Options used in the command line in the SQL Compare documentation.
  4. Click Save Options
    The options are saved for your database.

Sharing the options with your team

After saving, the options are only saved for your machine.

  • If your team uses the shared database model, the options will be applied to everyone else working on the database when they refresh or go to the Commit or Get latest tabs.
  • If your team uses the dedicated database model, you can share the options with other people working on the database by committing the change to source control.

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.

Default options

By default, the following options are enabled:

  • ConsiderNextFilegroupInPartitionSchemes
  • DecryptPost2kEncryptedObjects
  • DisableAndReenableDdlTriggers
  • DoNotOutputCommentHeader
  • ForceColumnOrder
  • IgnoreCertificatesAndCryptoKeys
  • IgnoreDatabaseAndServerName
  • IgnoreUserProperties
  • IgnoreWhiteSpace
  • IgnoreWithElementOrder
  • ThrowOnFileParseFailed
  • No labels