Ignore Collation doesn't seem to work

andymarksonline

I'm performing a diff with the following options:

Options.Default.Plus(new[]{Options.IgnoreCollations, Options.IgnoreComments, Options.IgnoreExtendedProperties, Options.IgnoreConstraintNames, Options.IgnoreQuotedIdentifiersAndAnsiNullSettings})

The diff is still showing columns that have differing collation in the two databases:

[ServiceReason] [varchar] (80) COLLATE Latin1_General_CI_AS NULL,
vs
[ServiceReason] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

Can you help please?

Andy.

andymarksonline

It does work I was diffing the scripts with collations but diffing the DBs without..