Apex SQL Clean 2011.01

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.

Keywords: sql tools, sql tool, unreferenced objects, unused objects, dependencies, visual diagram, dependency viewer, risk free delete

Click to enlarge

Author:

Apex SQL Tools     Other programs by Apex SQL Tools

Downloads:

199

Size:

7005K

Cost:

$299.00 US

Users Rating:

    Reviews (0)     Write review

Feedback:

Report broken download     Report spyware [?]

License:

Shareware [?]

Operating Systems:

Release Status:

update (2011-10-21)

Recent Changes:

Major Feature, Medium Fix Release

Supported Languages:

English

Additional Requirements:

ADO MDAC 2.8 MSSQL Server v7, 2000, 2005 or 2008, .NET 2.0 SP1 Run time

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

Service Account Manager
Report on and manage Windows Services

SQL Balance for MySQL
Compare and synchronize databases controlled by MySQL. Very fast!

Query Tool (using ODBC)
Query ODBC data sources, author SQL scripts and queries.

DreamCoder for Oracle Enterprise Freeware
Powerful tool for Oracle PL/SQL development and administration.

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

DreamCoder for PostgreSQL Enterprise Freeware
Powerful tool for PostgreSQL PL/pgSQL development

Query Tool (using ODBC) 7.0 x64 Edition
Query ODBC data sources, author SQL scripts and queries.

DBWScript
Convert .NET v3
DataGrid Columns .NET assembly
Columns .NET assembly for DataGridView
.NET Obfuscation Software
Skater .NET Obfuscator Standard
XMLFox Ultimate Edition
DataGridView Columns .NET assembly
Pacestar UML Diagrammer
XMLFox Advance XML and XSD Editor

EasyPattern Helper (382 dl.)
Skater .NET Obfuscator Standard (337 dl.)
MockupScreens (327 dl.)
DataGrid Columns .NET assembly (323 dl.)
Apex SQL Code (323 dl.)
Freeware .NET Obfuscator Skater Light (300 dl.)
Test Script Runner (296 dl.)
Submit Software Gold Suite (282 dl.)
USB Monitor Pro (275 dl.)
GeoMaker (275 dl.)