Tag Archives: compare object code between Production and development databases

Script to compare object code between two Production and development databases

Question : How to compare SQL Server Development and production boxes (two databases) in terms of object definition like Stored Procedures Triggers Views Function OR SQL Script to indentify databases objects where definition is not same. Solution This is a stored procedure to compare the code of the objects (Stored Procedures , Triggers , Views [...]