How to compare two Store Procedure

Posted by Saranya Boopathi under Sql Server on 6/18/2013 | Points: 10 | Views : 1108 | Status : [Member] | Replies : 2
Could anyone suggest good way to compare the content of the stored procedures?
Both Store Procedures are same but few lines are diferent..How to find that different lines in Two SP.
Because the SP in long.

Saranya Boopathi


Responses

Posted by: Niladri.Biswas on: 6/18/2013 [Member] Platinum | Points: 25

Up
0
Down
You could use one of the excellent third party products, such as

a) ApexSQL's SQLDiff (http://www.apexsql.com/sql_tools_diff.aspx)

b) RedGate's SQLCompare(http://www.red-gate.com/dynamic/products/sql-development/sql-compare/download)

c) Beyond comparer (http://www.scootersoftware.com/download.php)

d) Windiff (http://www.grigsoft.com/download-windiff.htm)

Best Regards,
Niladri Biswas

Saranya Boopathi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Allemahesh on: 6/18/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
You can use the third party control for this as Niladri suggested.

Saranya Boopathi, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response