To try to figure out what is going wrong we are going to need to try to reproduce the error. Would it therefore be possible for you to send the following to email@example.com
and include the support ticket number F0067228 in the subject line.
- a schema creation script for both objects in the comparison
- confirmation of the exact version number of SQL Data Compare e.g. 18.104.22.168
- confirmation of the exact version number of SQL Server involved e.g. 10.50.0.7600
- a copy of the generated deployment script giving you the error. As I assume that this is rather large for an email I can supply an ftp account for it.
I am happy for you to send me a different object if you are uncomfortable sending me the one involved, but only if you are confident that it gives exactly the same behaviour.