Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Compare store procedures?
Message
De
28/08/2020 12:21:37
 
 
À
28/08/2020 06:17:57
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
01675880
Message ID:
01675909
Vues:
56
>>Hi,
>>
>>Does SSMS have a feature where two stored procedures (in the same database, under different names) or in two different databases (with the same name) can be compared? In order to view the differences?
>>
>>TIA
>
>Hey, Dmitry,
>
>I use an application called WinMerge for this. It allows comparison of files of almost any type. I script each proc into a file then load them in WinMerge and let it show me the differences (if any).
>A free version of WinMerge should be available on the Web.
>
>Bill

I also use WinMerge. Very powerful. I add FoxBin2Prg by Fernando D. Bozzo. It allows you to convert SCX, VCX, FRX, etc. to text form where you can use WinMerge.

For WinMerge, nice features: Alt+Up/Down navigate difference to difference. And you can use Alt+Right/Left to copy code from one text file to the other. After updating, you can use FoxBin2Prg to put it back into SCX, VCX, FRX, etc. form. A really awesome combo for version comparison, or visualizing change history.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform