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.
Comments
1 comment
-
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
Add comment
Please sign in to leave a comment.