It provides an excellent source code repository and source code scanner. When developing a new application release, impact analysis is critical.
Any substantial release contains many structural database changes known as schema changes.
Before making any schema change, developers and DBAs need to know what application source code could be affected. When database changes are made without the proper impact analysis, the results can be disastrous. SQL Impact provides accurate and automatic impact analysis for any proposed structural database changes. It scans source code to parse and register the SQL access pattern, pinpoints precisely all lines of affected source code, and drills down to the actual source code , revealing the impact on both application source code and database objects. SQL Impact supports all of the most popular source code languages , including dynamic SQL .