I am using sql server 2012. I have a stored procedure which i am refactoring. The functionality is same between old and new SPs but the new Sp is faster and adheres to best practices and coding standards more. This Sp take 15 parameters. So i have atleast 30 scenarios where i need to perform testing, compare the results with old SP to ensure that the results of old SP and new SP are same. I already performed two rounds of such testing and i have some more changes to be done and need to test all the scenarios again.
Is there any way i can automate this? like i run all the queries for testing once and if any query fails message will be written to log file.
So for given set of input values i need to run old SP, save results in a file, run new Sp save results in a file compare both files and if they are same then log that its passed. Is this correct? If yes how to go about this?
Thanks for your time.