Compare two different stored procedures?

aspillert

A database has a stored procedure named "p_training" and another "p_training1". Can SQL Compare show me how they differ?

Andrew P

Hey aspillert,

Thanks for contacting us!
SQL Compare can compare a database to itself, however it only maps stored procedures based on object and owner name - so if you created "dbo.p_training" as well as "test.p_training" you could map those using Owner mapping - see documentation here https://documentation.red-gate.com/disp ... ing+owners

Warmly,

aspillert

This would be useful - please consider letting a user manually map a differently named items in a future version.
Thank you

RVO

What if my procedure names are different ?

AA.BBB
compare to
CC.KKK

How do I do that?

sam.blackburn

We don't support that currently, mostly because the mappings UI feels very complicated as it is. You could show your support for this idea at our UserVoice page, which has gathered a few votes.

ChrisBriggs

The ability to compare two stored procedures would be very helpful for development when you are working on a new version of a stored procedure and you want to go back and see what changed compared to the original.