What are the challenges you face when working across database platforms? Take the survey
Options

COMPARE to include collation info ?

rwillemainrwillemain Posts: 8
edited July 16, 2010 6:59AM in SQL Compare Previous Versions
Perhaps I am looking in the wrong places, but to compare two databases for differences in collations, where can I find this, if possible ?
Thsnk you. Rick

Comments

  • Options
    Thanks for your post.

    SQL Compare will compare the column level collations by default.

    When you look at the results grid after a comparison, select the table object from the top grid to view any collation differences in the 'SQL differences' pane at the bottom of the screen.

    You can ignore the collations on a column if you wish by checking the project option Ignore > Collations.

    SQL Compare won't show you the collation for the entire database as it will only compares at the object level.

    I hope this helps.
    Chris
Sign In or Register to comment.