These pages cover SQL Source Control versions 3.0 and later. Help for older versions is also available.

We've released a beta version of the improved migration script feature. We'd love to hear what you think.

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 Technical overview.

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.

    Icon
    To find out more about the effects the options have, see Setting project options 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 do this:

  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.

Icon
To find out more about committing changes, see Comitting changes.
  • No labels