CODEWITHSUNDEEP
c#visual-studiovisual-studio-2012schema-compare
Kliver Max
Kliver Max

Reputation: 5299

Visual Studio Schema compare issue

In Visual Studio i changed a field name in data base project. 

IdInInGeo -> IdInIngeo

After i do Schema compare but it's not recognized any changes in this table.
In Schema compares's Options i can't find a any settings about fields register (maybe because my english is weak).
How to make that Schema compare see fields name's changes like in my case? Any advises?

Upvotes: 3

Views: 2843

Answers (1)

Taher A. Ghaleb
Taher A. Ghaleb

Reputation: 5240

It happened to me one time. I could fix it using the following steps:

  • Go to your database's Project Settings
  • Tick right the checkbox entitled "Validate Casing on Identifiers"
  • Click on the button "Database Settings"
  • Under the "Data Collation" list, select: SQL_Latin1_General_CP1_CS_AS
  • Click OK

Doing so would most probably allow you to detect changes in schema names.

Do note that a one-character difference in the collation may lead to different results. For example, CI means case-insensitive, whereas changing it to CS makes it case-sensitive.

Hope this helps.

Upvotes: 3

Related Questions