Red Gate forums :: View topic - Fill Factor, Order Index & Nullable
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Fill Factor, Order Index & Nullable

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Matt Connors



Joined: 27 Feb 2013
Posts: 4

PostPosted: Wed Feb 27, 2013 7:51 pm    Post subject: Fill Factor, Order Index & Nullable Reply with quote

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
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 691
Location: Cambridge

PostPosted: Mon Mar 04, 2013 4:12 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Matt Connors



Joined: 27 Feb 2013
Posts: 4

PostPosted: Mon Mar 04, 2013 4:58 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 691
Location: Cambridge

PostPosted: Mon Mar 04, 2013 5:12 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Matt Connors



Joined: 27 Feb 2013
Posts: 4

PostPosted: Wed Mar 06, 2013 5:35 pm    Post subject: Reply with quote

Thanks Anu,

My apologies - the problem was mine.

I was not comparing data between the correct databases.

- Matt
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 691
Location: Cambridge

PostPosted: Wed Mar 06, 2013 5:37 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group