Problem: Tables Identified Different When They Are Not

bkolundzic

After installing SQL Compare 11, I ran V 10 and v 11 side by side for the same databases. The older version shows 41 tables being different, the new version shows 500.

Both projects have:

• Same filters
• Same project options set
• Access same servers
• Compare same databases
• Use case sensitive object definition unchecked
• Group by option set to Type of difference

The comparison on the new version:

• Seems to have issue with the table comparisons
• Seems to work comparing procedures, views, functions
• Groups false differences under the group for different objects
• Shows no differences and has no differences highlighted in the difference detail screen for majority of the tables appearing in the different object group
• Seems to compare tables correctly when their schema names have identical casing
• Seems to report tables as different when one schema name is uppercase and the other one has a title casing

I would appreciate any suggestion how to get around this issue. At the moment, I have to continue using V 10 until V11 remedy is available.

Thanks

Allen LeVan

Hello Branko,

This issue has been recorded as a bug in JIRA # SC-7719. The deployment script generated does not actually make any changes just the results page is displaying incorrectly. I will let you know of updates to the bug and an ETA on a fix when one is available, thanks.