How can we help you today? How can we help you today?

Fill Factor, Order Index & Nullable

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
Matt Connors
0

Comments

5 comments

Sort by
  • 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?
    Anu D
    0
  • 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
    Matt Connors
    0
  • Anu D
    These should be considered as differences by default in SQL Compare.

    Can you email me the screenshot indicating the issue?
    Anu D
    0
  • Matt Connors
    Thanks Anu,

    My apologies - the problem was mine.

    I was not comparing data between the correct databases.

    - Matt
    Matt Connors
    0
  • Anu D
    Thanks for confirmation Matt!

    I am glad this is sorted!

    Is there anything else I can help you with?
    Anu D
    0

Add comment

Please sign in to leave a comment.