Schema Compare - Ignore case differences between source and target
Question
Monday, November 10, 2014 5:00 PM
Hello,
I would like to use the "Schema compare" (with VS2012) tool which looks very great in order to industrialize my development team but I encounter several problems maybe due to my inexperience with that stuff.
Source:
CREATE TABLE [Schema1].[TABLE1]
Target:
CREATE TABLE [schema1].[TABLE1]
The tools retrieves this example as different, because of the case of "Schema1" and I don't want it. I have tried to figure out how it works and I have checked that my database collation in my project properties was "case insensitive" as my target database.
I have tried to check all "Ignore" boxes in the compare tools but same result...
Moreover even if I update the target with the tool, when I compare again the same difference shows up.
Has anyone an idea how I can ignore this difference ?
Your help would be very appreciated.
Thanks,
Nicolas
All replies (5)
Thursday, November 13, 2014 8:25 AM âś…Answered
The answer can be found here:https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d8e4598e-3f36-4433-8a73-1742bbb4b998/schema-compare-vs2012-n-difference-doesnt-apply?forum=ssdt
Monday, November 10, 2014 5:33 PM
See this thread.
Andy Tauber
Data Architect
The Vancouver Clinic
Website | LinkedIn
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.
Monday, November 10, 2014 6:44 PM
Are you using a case insensitive collation?
Please Mark This As Answer if it solved your issue
Please Mark This As Helpful if it helps to solve your issue
Visakh
My MSDN Page
My Personal Blog
My Facebook Page
Wednesday, November 12, 2014 8:13 AM
Hello,
Indeed I have already red this topic but I can't find the option "Ignore keyword spacing" (maybe it was on a previous version because he said he will migrate to 2012 at the end of the topic and I have already 2012 installed).
I have tried "Ignore keyword casing" but same problem...
Thank you for your help,
Cheers,
Nicolas
Wednesday, November 12, 2014 8:14 AM
Hello,
Yes I am using the collation "French_CI_AS" both for the target database and the project in visual studio 2012.
So I don't understand...
Thank you for your help,
Cheers,
Nicolas