Comparing using command line show different but not in GUI
After looking at the comparison report which is also generated by SQL Compare it shows me some objects with differences, but actually there looked identical.
Well, I try with the SQL Compare GUI and used the the same parameter I had used via the command line. The results was that it shows me no differences. Ok, this means is has something to do with the command line version of SQL Compare.
Well, after playing around with some parameters I tried to use the same constraint names in my snapshot folder and my target database to avoid this differences in general although I used the particular option to ignore it. After renaming the constraints on both targets my problem was solved.
I like to share my experience with this strange behavior of the command line from SQL Compare. May be you can reproduce it your environment.
If you need any further information, please let me know.
I used SQL Compare Version 10.2.0.1337