Subject Comparing two Sps
Author Didier Gasser-Morlay

I need to write a quite specific utility where I need to compare 2 sps
belonging to 2 databases and need you advice and ideas.

I have considered two possible options :

1) grab the stored procedure text, replace all tab, multiple spaces
and line feeds by a single space for both SP source code and then do a
simple compare

2) grab the BLR representation and compare both.

I assume that the BLR would be the same regardless of spaces, tab,
extra lines and that it would be probably be the safest comparison method.

Any comments or opinions will be very welcomed