Subject RE: [firebird-support] Comparing two Sps
Author Alan McDonald
> Hello,
> 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
> Didier

there are db compare utilities which use a reference and target db, they
compare and result in an alter statement for the procedure.
Is this no good for your purpose?