Sql Source Control 184.108.40.206 stopped including the fillfactor index options on table scripts. Every table shows a change now. Sql 2005 database level 80
SQL Source Control v220.127.116.11 includes a mechanism to allow comparison options to be configured – including Ignore Fill Factor. To get this version, please run Check For Updates from the Help menu in SQL Source Control.
Comparison options can now be set via a configuration file in your database repository’s Working Base folder. The following article describes how to configure this option: http://www.red-gate.com/SupportCenter/GeneralContent/knowledgebase/SQL_Source_Control/KB201202000521
Our plan in the future is to provide an options dialog to allow users to configure the comparison options that are changed most often, but we believe this configuration file procedure should help users in the interim.
If you’d like to see an options dialog exposing these settings in SQL Source Control, please vote on the following idea – https://redgate.uservoice.com/admin/forums/39019-sql-source-control/suggestions/2615460-add-an-options-dialog-to-allow-configuration-of-co – and let us know which options you’d like to see exposed in the dialog.
The options.xml file is on your local file system under:
C:\Users\[ntLogon]\AppData\Local\Red Gate\SQL Source Control 3\WorkingBases\[randomString]
You can poke about and figure out which database the [random string] folder is storing data for by looking at the tables or sps. You can then manually edit the xml option file to make it ignore some settings just like you do with SQLCompare.