I am trying to convert a VS2010 database project to a VS2012 database project. This database has a case-sensitive collation. But VS2012 seems to be ignoring the collations and complains about two objects with same name (in different case) to exist, in the same project.
For example, I have 2 database roles ABC_Role and Abc_Role. In ths case sensitive project, they should be recognized as 2 different roles but VS2012 database project doesn’t seem to like it. I tried to see if the same happens with tables too. And it behaves the same way. I tried messing with “Validating casing on Identifiers” setting on the Project Settings window, but that didn’t work.
Is there a way to make SSDT recognize the collation? Any help is appreciated.
Hima, To help the community better identify relevant thread, please don’t forget to mark as answer or vote as helpful if and answer helps.