I have a need for a constraint on a table e.g.
ALTER TABLE [dbo].[XXX] WITH CHECK ADD CONSTRAINT [CK_XXX_DateAddedRange] CHECK (([DateAdded]>='2014-03-14'))
which gets updated in our production environment daily. This conflicts with out Source Control system and the publish script has an entry to put it back to a previous date. If a filter could be included to remove specific objects from a comparison or publish (such as that offered by Redgate) I'd be able to keep Source Control in step with the real world, rather than one behind.