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.
In SQL Source Control, in the Setup tab, under Options just for this database, click Comparison options.
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.
By default, the following options are enabled:
After you save changes to the comparison options, the options are only saved on your machine.
To share the options:
Go to the Commit changes tab.
The change is shown waiting to be committed:
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.