BUG - Full Text catalog ACCENT_SENSITIVITY setting

Forum for users of SQL Compare schema synchronization utility

BUG - Full Text catalog ACCENT_SENSITIVITY setting

Postby jbelina » Tue Oct 23, 2012 4:01 pm

I believe I've found a bug in SQL Compare v10.2.0.1337

When comparing two script folders with the same collation and DB version, the Full Text catalog ACCENT_SENSITIVITY setting is showing up as a difference between the two script folders even though they are the same. If I use the deployment wizard to update the setting the file retains the OFF setting even though a refresh still shows the difference in SQL Compare.

I reran this comparison after upgrading to SQL Compare v10.2.3.1 but it still has the same behavior.

Both script folders have a default collation of SQL_Latin1_General_GP1_CI_AS with SQL Server 2008 as the version. This matches the database that I scripted out.

The folder generated by SSMS shows up as ACCENT_SENSITIVITY = OFF, the folder being compared is a folder from TFS and while the file itself says ACCENT_SENSITIVITY = OFF, the setting shows up in SQL Compare as ACCENT_SENSITIVITY = ON.
Posts: 8
Joined: Mon Aug 08, 2011 4:32 pm
Location: USA

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: Bing [Bot] and 0 guests