A few databases were recently migrated from SQL Server 2005 to SQL Server 2008, and I have to check if all the stored procedures, and triggers still work well. With 'checking', I mean that I should guarantee that they are compilable and executable.
There are many stored procedures and triggers to check. To do it manually, I would need maybe 1 month. So, I want to take another approach.
What kind of checking procedure would you recommend me, so that I can say surely that the stored procedures and triggers will also work in SQL Server 2008?
Thanks
Best Answer
Generally speaking, if you just reapply of the stored procedures and no errors show up, you should be good to go (based on my experience from migrating 2 databases (2000->2005) (2005->2008). On a side note, this is why we started writing unit tests for our database code to handle problems like these.