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

SQL Compare 11.0,11.1 does not sync every Stored Procedure

It shows me the differences in schema and deploys it successfully but on recomparison after deployment it still shows some procs as being different.
The options that have turned on are Object existence checks, donot use transactions.
gsbajwa
0

Comments

2 comments

Sort by
  • EZLinks
    I have been experiencing the same issue with SQL Compare 11. It does not occur with SQL Compare 10, so I am not able to upgrade until this bug has been fixed.
    EZLinks
    0
  • Mike U
    There was a bug in SQL Compare 11.0 and 11.1 (our reference SC-7610) which caused the object existence checks option to generate incorrect checks, and therefore not actually update stored procedure definitions. I'm pleased to tell you that this bug has been fixed in the latest version of SQL Compare, 11.1.2.28. You can get this version via Help -> Check for Updates..., or you can download it from here (release notes).
    Mike U
    0

Add comment

Please sign in to leave a comment.