Ignore DEFAULT statements?

tkdennis

I'm trying to compare just the column names and data types between two databases. I checked every option under "Ignore" on the Options tab.
Many tables in one database have DEFAULT statements on the columns and these are causing the tables to be considered different. Is there a way to ignore the DEFAULT part?

date_entered datetime NOT NULL DEFAULT (getdate())

comparing to

date_entered datetime NOT NULL

Thanks,
Traci

David Atkinson

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

tkdennis

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

jeffgonnering

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.

dba-robin

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

GregWhite83

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"

chris.mcgoo

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

ghankot

Please add my vote for this option. Thanks!

MadsRavn

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.

KlausWiesel

And another vote , would really add value

StuartN

And another vote from me.

RichardL

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. 

cparko

Please add my vote to ignore defaults

kalo

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