Fill Factor, Order Index & Nullable

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Fill Factor, Order Index & Nullable

Postby Matt Connors » Wed Feb 27, 2013 7:51 pm

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
 
Posts: 4
Joined: Wed Feb 27, 2013 7:40 pm

Postby Anu Deshpande » Mon Mar 04, 2013 4:12 pm

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby Matt Connors » Mon Mar 04, 2013 4:58 pm

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
 
Posts: 4
Joined: Wed Feb 27, 2013 7:40 pm

Postby Anu Deshpande » Mon Mar 04, 2013 5:12 pm

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby Matt Connors » Wed Mar 06, 2013 5:35 pm

Thanks Anu,

My apologies - the problem was mine.

I was not comparing data between the correct databases.

- Matt
Matt Connors
 
Posts: 4
Joined: Wed Feb 27, 2013 7:40 pm

Postby Anu Deshpande » Wed Mar 06, 2013 5:37 pm

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest