Comparing differently named stored procedures
Captain Cursor
Posts: 2
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
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
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