Can I exclude comparison of collation?

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Can I exclude comparison of collation?

Postby msandico » Thu Aug 16, 2012 3:15 pm

Hi All,

I'm comparing two databases and i would like to know if i can EXCLUDE the comparison of collation between objects. For databaseA, it is collation A, and for databaseB, it is collationB.

For many of the objects, SQL COmpare is reporting a difference due to collation differences at the column level. But i dont want to see this as i know collation is a non-factor for this particular app and collations.

Let me know, thanks!
msandico
 
Posts: 6
Joined: Thu Aug 16, 2012 3:12 pm

Postby David Atkinson » Mon Aug 20, 2012 11:03 pm

Have you tried the 'Ignore Collations' option?
(Edit Project / Options)
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Re:

Postby msandico » Tue Aug 21, 2012 2:03 pm

David Atkinson wrote:Have you tried the 'Ignore Collations' option?
(Edit Project / Options)


Perfect thank you!!
msandico
 
Posts: 6
Joined: Thu Aug 16, 2012 3:12 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 2 guests