OracleGuy





Remember me

[Register]

Previous Posts By Category

Database Object Scanner

This program is designed to find orphaned database objects that usually happen over many software revisions and are even more common with poor documentation. What it does is, it accesses your database and retrieves a list of all the database objects: tables, stored procedures, views, etc. and then it can scan your application and/or web source for references to these objects. It then generates a report that lists all the found objects, how many times they were found, if they were found in the application source and/or the web source, and the last place it was found.

Once the scanner is done analyzing your database, it generates a report and from which you can see which objects are no longer in use in your code and can be removed. Plus on top of that, if something is found only once it tells you where and you can view your code to see if it is still needed. You can view a sample copy of the report if you'd like.

It supports Access, Microsoft SQL Server, and MySQL databases.

Database Object Scanner Files

Here are all related files in the database for Database Object Scanner.

  • DBOS Beta 3 Full - Download Count: 2327
    This is the beta 3 build of the Database Object Scanner, in it are more bug fixes and completed features. This is a full install package and should theoretically upgrade your beta 1 or 2 installations but if not, just uninstall it and install beta 3.
  • DBOS v2.0 Beta 2 Patch - Download Count: 2432
    This is the Beta 2 patch (183KB), it will upgrade the Beta 1 installation to Beta 2 so you need to install the Beta 1 first.
  • DBOS v2.0 Beta 1 - Download Count: 2543
    This is the first beta of the Database Object Scanner. Feeback is wanted, especially relating to bugs.