Comparewith option IngoreFillFactor

jinfor

I have the following statement in my .Net code:

Dim differences As Differences = db1.CompareWith(db2, Options.IgnoreFillFactor)

When I run my code over two db's I get a return on a table that has only a fill factor difference (we verified this with the actual SQL Compare tool).

Any idea why my code is not actually ignoring tables with fill factor differences?

Thank you!

Jinfor

jinfor

We think we found it - we had more than one option and had AND instead of OR between them.

Brian Donahue

That would do it -- you can make life a little easier by using the already set default options and then adding your own changes with a bitwise OR:

Options enOptions=Options.Default|Options.IgnoreFillFactor