Fill Factor, Order Index & Nullable

Matt Connors

Hello,
I've got a newbie question.

We're in the process of upgrading versions of a large package system.
I created a project to compare the old db to the new db.

I noticed that when I run the compare it does not recognize changes in the Fill Factor, Order Index or Nullable column attributes.

Are there some options I can set to ensure these differences get picked up?

Thanks,
Matt

Anu D

Thanks for your post Matt!

Can you make sure you have this default option unchecked?

In SQL Compare UI navigate to:

Tools --> Project Options --> Options --> Ignore --> Fill factor and Index padding

Does this make any difference?

Matt Connors

Thanks Anu,

Yes, that takes care of the Fill factor issue but I am still seeing that the comparision does not seem to recognize differences in:

Column Size - Specifically when the column size is reduced (i.e char(18) -> char(16)

Nullable - That is going from NULL to NOT NULL

Are there configuration options for these as well?

Thank you,
Matt

Anu D

These should be considered as differences by default in SQL Compare.

Can you email me the screenshot indicating the issue?

Matt Connors

Thanks Anu,

My apologies - the problem was mine.

I was not comparing data between the correct databases.

- Matt

Anu D

Thanks for confirmation Matt!

I am glad this is sorted!

Is there anything else I can help you with?