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

Comments
3 comments
-
In the edit project dialog, do you have the Ignore Whitespace option checked?
-
Thanks Sam, that was it.
-
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.
Add comment
Please sign in to leave a comment.