Apex SQL Clean 2008.02

Apex SQL Clean 2008.02 is a powerful tool to find out and delete unreferenced and unused Database objects like tables, views and procedures from within the database itself (cross-dependencies) and also from client applications (like a VS.NET project).

References are created using proprietary technology that doesn't rely on SQL system tables. Apex SQL Clean includes a powerful visual Dependency viewer that converts database dependies into a graphical display. Apex SQL Clean will analyze a client whether it be VB, ASP, Delphi etc to determine what SQL objects are actually being used and what objects aren't.

It will also analyze the database itself to see what internal references exist among SQL objects. Based on the Apex SQL Clean analysis it will generate a file of SQL drop statements to Clean your database of these useless objects.

Major Features: 

1. Support for tables, views, procedures, rules, defaults, triggers, user defined datatypes, user defined functions and file dependencies
2. Interface shows Object dependencies and objects with dependencies to it.
3. Graphical display of number of unreferenced objects. 
4. DDL script for object colorizes referenced object names to allow you to visual spot the dependencies. 
5. Users have the ability to create file search pattern to analyze all files of a particular language or project (i.e .cs, .vb, .frm, .aspx, .pas, .cls) 
6. The file processing engine is recursive simply point to a directory and it will search all subdirectories for files that match the search pattern you create. 
7. Automatic drop statement creation. Interface shows whether file is referenced, has references and the number of each. Simply clicking on the object will display all references. 
8. Double clicking on any object will script it. 
9. Interface supports grouping/ungrouping by object type.
10. Column level dependencies
11. Proprietary Dependency parsing algorithms for SQL 7, 2000 and 2005 that provide accurate dependency analysis vs native SQL Server methods that use sysdepends table
12. SQL Server 2005 Support
13. New Auto-update feature
14. Regular expression object filter
15. Graphical Dependency Viewer
16. Support for tables, views, procedures, rules, defaults, triggers, user defined datatypes, user defined functions and file dependencies
17. Interface shows object dependencies and objects with dependencies to it.
18. Graphical display of number of unreferenced objects.
19. DDL script for object colorizes referenced object names to allow you to visual spot the dependencies.
20. Users have the ability to create file search pattern to analyze all files of a particular language or project (i.e .aspx, .cs, .pas, .cls)
21. The file processing engine is recursive - simply point to a directory and it will search all subdirectories for files that match the search pattern you create.
22. Automatic drop statement creation.
23. Interface shows whether file is referenced, has references and the number of each. Simply clicking on the object will display all references.
24. Double clicking on any object will script it.
25. Interface supports grouping/ungrouping by object type.
26. Unicode support
    

Enhancements:

• Updated product

Requirements:

• ADO MDAC 2.8 MSSQL Server v7,
• Win2000, 2005 or 2008,
• NET 2.0 SP1 Run time
• NET Framework 1.1

WareSeeker Editor