SQL Compare missed a difference between two stored procedures

ebwind

SQL Compare missed a stored procedure where there was a space before a colon - see attached.

sam.blackburn

In the edit project dialog, do you have the Ignore Whitespace option checked?

ebwind

Thanks Sam, that was it.

Chris_F

If that fixed it then that definitely should be a bug.

White-space should be classed as the white-space around statements, not within a literal string.

If a statement is preceded with 2 tabs instead of one that's no issue, but if there is a string/code different then that is a major issue if it gets missed.

SQL Compare should be smart enough to pick up the difference between the two.