Column Description Comparison by Column Name

RileyM

When comparing a table with column descriptions, the column descriptions should match up based on column name. SQL Compare seems to do it alphabetically, leading to the appearance of changes where none occurred.

Harry Frankish

Hi RileyM

Thanks for the suggestion. I wonder if SQL Compare's new Summary view might help as it will only show you what has changed on the database rather than a textual difference in the create script. You can read more about the Summary view here: https://forum.red-gate.com/discussion/81060/beta-feature-for-sql-compare-summary-view

Please let us know if this helps.

Many thanks
Harry