Comparing differently named stored procedures

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Comparing differently named stored procedures

Postby Captain Cursor » Tue May 08, 2012 4:22 pm

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


Captain Cursor
Posts: 1
Joined: Tue May 08, 2012 4:16 pm

Postby stanori » Thu May 10, 2012 6:04 pm

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.
Posts: 84
Joined: Mon Apr 23, 2012 1:13 pm

Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest