Compare two different stored procedures?

• 
  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 P December 17, 2016 01:55

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

  aspillert December 19, 2016 15:42

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

  RVO March 06, 2017 11:55

  - 0 +
• 
  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.

  sam.blackburn March 07, 2017 12:39

  - 0 +
• 
  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. 

  ChrisBriggs July 07, 2021 13:21

  - 0 +

Add comment

Please sign in to leave a comment.