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
>
>
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
>
>