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

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.)

Thanks,

CC

Comments

  • 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
    _________________
    Steve Tanori
    Product Support
    Red Gate Software Ltd.
    866-997-0378
Sign In or Register to comment.