What are the challenges you face when working across database platforms? Take the survey
Options

Fill Factor, Order Index & Nullable

Matt ConnorsMatt Connors Posts: 6
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

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    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?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    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
  • Options
    Anu DAnu D Posts: 876 Silver 3
    These should be considered as differences by default in SQL Compare.

    Can you email me the screenshot indicating the issue?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    Thanks Anu,

    My apologies - the problem was mine.

    I was not comparing data between the correct databases.

    - Matt
  • Options
    Anu DAnu D Posts: 876 Silver 3
    Thanks for confirmation Matt!

    I am glad this is sorted!

    Is there anything else I can help you with?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.