Apex SQL Clean 2011.01
|
Apex SQL Clean screenshot  |
Apex SQL Clean tool looks for and deletes 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. Features - Support for tables, views, procedures, rules, defaults, triggers, user defined datatypes, user defined functions and file dependencies - Interface shows Object dependencies and objects with dependencies to it. - Graphical display of number of unreferenced objects. - DDL script for object colorizes referenced object names to allow you to visual spot the dependencies. - 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) - 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. - 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. - Double clicking on any object will script it. - Interface supports grouping/ungrouping by object type.
Program Details
| Released: | 2011-10-21 |
| More: | All programs by this author |
| Downloads: | 255 |
| License Type: | Shareware |
| Platform: | Win7 x32,Win7 x64,WinVista,WinVista x64,WinXP |
| Homepage: | http://www.apexsql.com/sql_tools_clean.aspx |
| Price: | $299.00 US |
Related Listings
|
Apex SQL Script Apex SQL Script converts databases to scripts, .net exe's, deployment packages |
|
Apex SQL Log Apex SQL Log is a database auditing and recovery solution |
|
4TOPS Query Tree Editor for MS Access 4TOPS Query Tree Editor for MS Access for query development |
|
Apex SQL Report Apex SQL Report is a data driven web reporting solution for Microsoft SQL Server |
|
dbForge Studio for Oracle Powerful Oracle database development tool. Packed with features, great UI |
|
Apex SQL Edit Apex SQL edit is an integrated SQL database editing tool/IDE |
|
|
EMS SQL Management Studio for PostgreSQL A complete solution for PostgreSQL database administration and development |
|
Apex SQL Clean Apex SQL Clean - risk free delete, impact analysis and visual dependency viewer |
|
|
EMS SQL Management Studio for MySQL A complete solution for MySQL database administration and development |
|
|
EMS SQL Management Studio for SQL Server A complete solution for SQL Server administration and database development |
|
EMS SQL Manager for MySQL Freeware Excellent freeware graphical tool for MySQL Server administration. |
|
|
EMS SQL Manager for MySQL State-of-the-art GUI tool for MySQL Server administration and development. |
|
EMS SQL Manager for PostgreSQL Powerful graphical tool for PostgreSQL DB Server administration and development. |
|
|
EMS SQL Manager for PostgreSQL Freeware Light and easy-to-use freeware graphical tool for PostgreSQL administration. |
|
EMS SQL Manager for SQL Server Powerful graphical tool for SQL Server administration and development. |