SQLCompare when sychronising is not copying over case

jonswainojonswaino Posts: 18
edited March 18, 2010 1:23PM in SQL Compare Previous Versions
We have an sproc which fails on the server because the sproc is in mixed case. I can see that our scripts folder has the sproc in all upper case. However after sync has completed, if I check the SQL server, the sproc case hasn't been changed. Why are these changes not being copied across?
· Share on Twitter

Comments

  • Chris AucklandChris Auckland Posts: 769
    Thanks for your post.

    Can you check to see if you're using 'Use casesensitive object definition' in your comparison?

    It's under Edit Project > Options > Behaviour.

    I hope this helps.
    Chris
    · Share on Twitter
Sign In or Register to comment.