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

Case insensitivity issue

In my databases, if SQL Compare picks up a difference in a stored procedure, say CREATE vs Create it will correctly flag this procedure for update. On a case insensitive install of SQL Server, however, the procedure will not be updated and a refresh of the comparison will once again flag the procedure for update.

Would it be possible to add an option for drop procedure (or function, etc) and re-create so that case insensitivity is no longer an issue?

Thanks!
--Brian
bmerz
0

Comments

2 comments

Sort by
  • Michelle T
    We've looked at adding an option to always drop and recreate procedures etc (for several reasons), but we find that doing so opens up a wide range of dependancy issues, so we haven't managed to implement it satisfactorily yet.

    I've attached this forum post to the relevant feature request.

    Is it also worth attaching it to the feature request for the ability to ignore differences in case for CREATE statements on case insensitive servers, or would that not solve your problem?

    (We're unlikely to implement either of these in version 7 itself, but they'll be up for consideration for future releases.)
    Michelle T
    0
  • bmerz
    So long as ignore case only ignores keywords such as CREATE adding that to the ignore options should do the trick.
    bmerz
    0

Add comment

Please sign in to leave a comment.