How to compare two Store Procedure

Posted by Saranya Boopathi under Sql Server on 6/18/2013 | Points: 10 | Views : 2120 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

Latest Posts