Options
COMPARE to include collation info ?
rwillemain
Posts: 8
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
Thsnk you. Rick
Comments
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.