Ignore DEFAULT statements?

tkdennis · April 14, 2009 7:53PM

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 · April 15, 2009 4:16AM

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 · April 15, 2009 7:36PM

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 · September 28, 2011 10:02AM

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 · February 3, 2015 11:00AM

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

GregWhite83 · September 2, 2015 6:35AM

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 · January 4, 2016 5:45PM

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

ghankot · May 5, 2016 1:05PM

Please add my vote for this option. Thanks!

MadsRavn · November 23, 2017 2:57PM

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 · January 26, 2018 11:19AM

And another vote , would really add value

StuartN · June 19, 2018 10:05AM

And another vote from me.

RichardL · June 22, 2018 3:07PM

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 · September 11, 2019 6:09PM

Please add my vote to ignore defaults

kalo · October 25, 2024 1:07PM

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

Ignore DEFAULT statements?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk