What are the challenges you face when working across database platforms? Take the survey

Comparing differently named stored procedures

Captain CursorCaptain Cursor Posts: 2
edited May 10, 2012 1:04PM in SQL Compare Previous Versions
Hiya guys.

The situation I have is that I have a stored proc, let's say called up_DoSomething. Due to a lack of rigour in the config management department, there are several versions of this SP, let's say called

up_DoSomething_2012, up_DoSomething_Interim, etc, etc.

What I need to do is to compare any of the procs with any other - also I am on SQL Compare 9. Can this be done? (please say yes.)




  • Options
    Hi Captain Cursor,

    Unfortunately, you can only map tables and views with different names. This is not possible with Stored Procedures.

    Best Regards,
    Steve Tanori
    Product Support
    Red Gate Software Ltd.
Sign In or Register to comment.