I just updated to SQL Compare 10 on our build server, and now when I sync the database I get the following error:
Column names in each table must be unique. Column name 'foo' in table 'dbo.bar' is specified more than once.
I changed the build script to use version 9 instead and then it worked fine. Do I need to specify some new parameter to make version 10 work the same way as 9?