Problem Comparing tables with different fill factors

Brian Donahue

Hello Matt,

My name is Brian Donahue, and I am a support engineer with Red Gate
Software. Just to keep you updated, I've reproduced the problem you've
described on a table in my test database which behaves like you say: not
ignoring the fill factor as it should. I have another table where the fill
factor was properly ignored. We have to figure out what the differences are
in the tables to track down the problem.

I'll keep you updated.

Thanks for your interest in Red Gate Software.

Regards,
Brian Donahue

"M@" <Not@Submitted> wrote in message news:6rVOBKgpCHA.1156@server53...
> I am attempting to compare two databases in SQL Compare 2.02. The problem
is
> that one of them has a fill factor set for each table and the other does
> not. As a result, I get a difference in the compare grid for every table.
I
> set the option in "View -> Options" to ignore fill factors, rescripted
both
> databases, and ran the comparison again and got the exact same results. It
> seems that SQL Compare is completely missing the "Ignore Fillfactor"
option
> when doing a comparison. I need to be able to compare indexes (especially
> primary keys) but ignore fill factors.
>
> This database has over 500 tables and as it is now I have to open each one
> up from the comparison grid and uncheck "Show Indexes" to prevent the
> fillfactor difference from causing every table to show up as changed, but
> that defeats the purpose of what I am doing.
>
> Since clients' DBAs manage their own optimization of their servers,
> fillfactors can and do vary.
>
> Is there any way to compare indexes while ignoring differing fill factors?
> If so, how do I set that up?
>
> Thanks,
>
> M@
>
>