Hello Red Gate team,
earlier today I did a compare of two databases and wondered about the results shown in the SQL Differences pane. So for example in line 50 of the target table a column is listed, which is marked for dropping whereas it is also listed in the source table in line 53 (it's a bit hard to explain).
The Deployment Wizard does get it right, though. The deployment script does not show any changes for the column in question.
I noticed the 'Example: ignoring column order' entry stating that changes would still be highlighted (when ignoring the column order), even if the tables would be marked as identical. So I wondered, whether my 'problem' is really by design. But nevertheless it is confusing, if one is only looking for changes made in the source database and is shown more than the expected difference(s).
I couldn't find any options in 'Edit Project' settings, which seemed to change this behaviour. Is there something I missed or are there any plans to change the default behaviour?