Problem Comparing tables with different collations

Brian Donahue

Hi,

The problem was not the collation, but the fact that the two tables had
different settings for allowing NULLS:

ie:
Table 1:
[column1] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,

Table 2:
[column1] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,

But for everyone's information, you can set SQL Compare to ignore
collation order through Tools->Options Objects tab.

Brian Donahue

Technical Support Engineer

Red Gate Software Ltd.

+44 870 1600 037

mailto:brian.donahue@red-gate.com



"Andrea Masi" <amasi@RandomResearch.it> wrote in message
news:TN3rAE#vCHA.544@server53...
> I am attempting to compare two databases with different cpllations in SQL
> Compare 2.02.
> As a result, I get a difference in the compare grid for every table. I
> set the option in "View -> Options" to collation order, rescripted both
> databases, and ran the comparison again and got the exact same results. It
> seems that SQL Compare is completely missing the "Ignore collation order"
> option
> when doing a comparison.
>
> Is there any way to compare while ignoring differing collations?
> If so, how do I set that up?
>
> Thanks,
>
>
> Andrea Masi
> Random Research s.r.l.
> ROME - ITALY
> www.RandomResearch.it
>
>