Compare Stored Procedures

Is there a way to compare Stored procedure definitions
in different databases?
Eg. I have database A with Stored procedure Sp1
and database B with Stored procedure Sp1
how can I compare the definitions of Sp1 in two databases?
Thank you in advance-
-Asok
Check out SQL Compare by Red-Gate at www.red-gate.com
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Asok" <anonymous@.discussions.microsoft.com> wrote in message
news:fca701c43e95$7d34d480$a101280a@.phx.gbl...
> Is there a way to compare Stored procedure definitions
> in different databases?
> Eg. I have database A with Stored procedure Sp1
> and database B with Stored procedure Sp1
> how can I compare the definitions of Sp1 in two databases?
> Thank you in advance-
> -Asok
|||Several tools listed here:
http://www.aspfaq.com/2209
In addition, you could script your stored procedures to a file and use
WinDiff (which ships with Visual Studio).
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Asok" <anonymous@.discussions.microsoft.com> wrote in message
news:fca701c43e95$7d34d480$a101280a@.phx.gbl...
> Is there a way to compare Stored procedure definitions
> in different databases?
> Eg. I have database A with Stored procedure Sp1
> and database B with Stored procedure Sp1
> how can I compare the definitions of Sp1 in two databases?
> Thank you in advance-
> -Asok
|||Hi,
Try dbMaestro. It's a product that allows comparison, migration and archiving of database schema and data.
You can find it here:
http://www.extreme.co.il