Compare two different stored procedures?

Comments

• Andrew P Redgate › Posts: 194 Silver 3

  December 17, 2016 1:55AM

  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,

  Andrew Pierce
  Technical Sales Engineer
  Redgate Software

  0 · Share on Twitter
• aspillert Posts: 20

  December 19, 2016 3:42PM

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

  AlanCHB

  0 · Share on Twitter
• RVO Posts: 4 New member

  March 6, 2017 11:55AM

  What if my procedure names are different ?
  
  AA.BBB
  compare to
  CC.KKK
  
  How do I do that?

  0 · Share on Twitter
• sam.blackburn Redgate › Posts: 224 Gold 2

  March 7, 2017 12:39PM

  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.

  Software Developer
  Redgate Software

  0 · Share on Twitter
• ChrisBriggs Posts: 2 New member

  July 7, 2021 1:21PM

  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. 

  0 · Share on Twitter