SQL Compare 11.0,11.1 does not sync every Stored Procedure

gsbajwagsbajwa Posts: 2
edited January 26, 2015 7:53AM in SQL Compare 11
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.
· Share on Twitter

Comments

  • EZLinksEZLinks Posts: 10 Bronze 2
    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.
    · Share on Twitter
  • Mike UMike U Posts: 316 Gold 1
    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).
    Development Lead
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.