Hi

We use SQL Server 2012 and have stored procedures in Dev and Live environment. When we decide to move changes made to Dev TO Live, we need to be able to compare the scripts in Dev and Live and see the changes so that we can analyse the impact of the same and plan accordingly. We use the Generate Scripts option in both environments, however, the scripts do not come in the same order in each of them and hence it becomes very difficult to compare them. Would you be able to suggest a tool which can give the changes in the same order so that taking a DIFF of them would be easy ? OR will you be able to share something you have developed to know the list of changes made to all Stored procedures in a given range of dates ?

Regards

Mannulal