How can we help you today? How can we help you today?

Can I exclude comparison of collation?

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
0

Comments

2 comments

Sort by
  • David Atkinson
    Have you tried the 'Ignore Collations' option?
    (Edit Project / Options)
    David Atkinson
    0
  • msandico
    Have you tried the 'Ignore Collations' option?
    (Edit Project / Options)

    Perfect thank you!!
    msandico
    0

Add comment

Please sign in to leave a comment.