How can we help you today? How can we help you today?

SQLCompare when sychronising is not copying over case

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?
jonswaino
0

Comments

1 comment

Sort by
  • Chris Auckland
    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 Auckland
    0

Add comment

Please sign in to leave a comment.