Ignore DEFAULT statements?

• 
  Hi Traci,
  
  Unfortunately there's no option to ignore DEFAULTs in SQL Compare. Of course we're happy to consider this as an option for a future release as long as we get sufficient requests.
  
  Kind regards,
  
  David Atkinson
  Product Manager
  Red Gate Software

  David Atkinson April 15, 2009 04:16

  - 0 +
• 
  PLEASE do consider it for a future release. This database has 277 tables and most of them have one or more DEFAULT statements on them. My database doesn't care about anything else except that the column names and datatypes have not been changed for any table so I'm having to manually check the highlighted changes for each table marked different.
  
  Thanks!
  Traci

  tkdennis April 15, 2009 19:36

  - 0 +
• 
  I vote for adding a "ignore defaults" to the options as when I compare a replicated database (subscriber) to publisher, the only differences are default constraints, and I don't care about those since only the publisher will have those constraints. So I may get 200 differences, 199 are due to default constraints, and 1 table has a "real" difference, so I have to weed through 200 objects. Thank you.

  jeffgonnering September 28, 2011 10:02

  - 0 +
• 
  And here we are in 2015 and there's still no IGNORE DEFAULT option.

  dba-robin February 03, 2015 11:00

  - 0 +
• 
  I would like to vote for this to be added, the reason its useful is because I am comparing a replicated database the source has default values for columns but the destination dosent (not needed or replicated). So when comparing I have to filter out these manually from deployment scripts. I have tables with 200+ columns. Notepad find and replace "gets round it"

  GregWhite83 September 02, 2015 06:35

  - 0 +
• 
  Add my vote to that wishlist.
  Nearly impossible to use SQL Compare 11 with a large replicated db with lots of DEFAULT contraints!

  chris.mcgoo January 04, 2016 17:45

  - 0 +
• 
  Please add my vote for this option. Thanks!

  ghankot May 05, 2016 13:05

  - 0 +
• 
  Another vote for this feature (is it that hard when you support ignoring check constraints?). Right now I cannot use your tool to do a comparison (at least without post-processing), since a "transactional replica" will not contain any default constraints.

  MadsRavn November 23, 2017 14:57

  - 0 +
• 
  And another vote , would really add value

  KlausWiesel January 26, 2018 11:19

  - 0 +
• 
  And another vote from me.

  StuartN June 19, 2018 10:05

  - 0 +
• 
  Hi @ghankot @MadsRavn @KlausWiesel @StuartN
  
  Thank you for your posts. 
  
  Please add votes on the UServoice page for SQL Compare in the link below. 
  
  https://redgate.uservoice.com/forums/141379-sql-compare
  
  Kind regards
  
  Richard Lynch.

  RichardL June 22, 2018 15:07

  - 0 +
• 
  Please add my vote to ignore defaults

  cparko September 11, 2019 18:09

  - 0 +
• 
  Slightly annoying that this isn't an option - at least thanks to this thread i know i'm not going crazy why I can't get my databases to show as identical ignoring this - and can't auto-script deployment but ignore this

  kalo October 25, 2024 13:07

  - 0 +

Add comment

Please sign in to leave a comment.