Is there an ability in any of the RedGate tools to run some sort of bulk validation for all SQL objects (views, stored procedures, functions, etc.) - to ensure the code is still valid? The scenario is that we have a database with a bunch of custom objects that access a 3rd party application database. We're upgrading the application and know that there are quite a few schema changes to the application tables. We'd like to run a process that identifies what SQL objects are referring to obsolete columns, etc.
Is there an ability in any of the RedGate tools to run some sort of bulk validation for all SQL objects (views, stored procedures, functions, etc.) - to ensure the code is still valid? The scenario is that we have a database with a bunch of custom objects that access a 3rd party application database. We're upgrading the application and know that there are quite a few schema changes to the application tables. We'd like to run a process that identifies what SQL objects are referring to obsolete columns, etc.