COMPARE to include collation info ?

rwillemain

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

Chris Auckland

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.