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

Thanks,

CC
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
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
stanori
 
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 0 guests

cron