Your database model just changed, what else is affected?

What are you needing to do?

• I need a syntax aware scanner to search all of my programming language source code and text-based ( log or config ) files to see everywhere a text string, field, variable or code snippet is referenced.
• I would like to search and document all of my Crystal Reports, other types of reports, relational databases, program source code and more to locate everywhere a database field, variable or code snippet is used.
• We need a search and replace tool to change data source connections or set DSN table alias names across a large number of Crystal Reports.
• We need to create a database cross reference report and/or extract and search embedded SQL code within Crystal or Oracle reports.
• We are looking for a source code change management tool to aid in automating some of our agile software team processes to improve overall productivity and expedite impact analysis. We need to be able to save and share search results with annotations among team members.
• I would like to pinpoint where any of our reports or programming source code may be affected by a data model change. The database may be our own or one provided by a vendor that we have written reports and external interface programs against and has changed due to a release upgrade.