Problem comparing SPs that are numbered

Forum for users of SQL Compare schema synchronization utility

Problem comparing SPs that are numbered

Postby lslmustang » Mon Jul 28, 2014 6:53 pm

There has always been a problem with numbered stored procedures for a compare as it does a CREATE for all the sprocs when it should be an ALTER. But recently I updated to 10.7 and now it highlights procedures that are the same but not the same in Redgate for several that use numbers. It is not seeing all the numbered sps.
Although this feature is to be deprecated, it is not currently.
It's showing differences between 2 databases and one is a restored version of the other.

Posts: 4
Joined: Tue Mar 07, 2006 2:13 pm

Postby kevinsalot » Wed Jul 30, 2014 7:03 pm

I found a similar post with what seems to be the same issue. ... t=numbered

This was working for me in SQL Compare 8. We purchased SQL Compare 10 in order to get support for SQL Server 2012. Since the upgrade we have had unreliable comparisons for our SPs.
- Kevin
Posts: 3
Joined: Wed Jul 30, 2014 6:53 pm

Postby Evan Moss » Thu Jul 31, 2014 3:28 pm


I just did some testing and it appears this works better in the 11.0 beta. Can you try using that version to see if that helps? You can get more information on the beta here: ... hp?t=20075

Evan Moss
Product Support
(866) 627-8107
Evan Moss
Posts: 112
Joined: Wed Jun 12, 2013 8:56 pm

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests