Windows | IT & Network Administration | Database | Apex SQL Clean

Apex SQL Clean - 2005.09.0127

deletes unreferenced & unused database

Download Now

(File Size: 14.3M)

Free Product Alerts!

All Time:	Not rated (0.0)
This Version:	Not rated (0.0)
Current Version:	2005.09.0127
Release Date:	2007-12-13
License:	Commercial
Downloads (this version):	598
Downloads (all versions):	1,549
Price:	$249.00

Information Related to Version:

Broken Link? Newer Version? Tell us!

Product Description:

Apex SQL Clean looks for and deletes unreferenced and unused database objects like tables, views and procedures.

If database object bloat is the problem, Apex SQL Clean is the solution. Your database may have many stored procedures, tables and views that aren't being used anymore but unless you determine which of your objects fall into this category you will be stuck with them forever.

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 this analysis it will generate a file of SQL drop statements to clean your database of these useless objects.

What's new in this version:

Fixes:

User types having references are shown as unreferenced under SQL Server 2000
Generating incorrect drop script for aggregates from SQL Server 2005 databases
Missing queue schema when generating drop script for on-queue event notifications
Missing references for scripting with different casing in case insensitive databases
Missing references for event notifications over queues in some cases
Some objects reported unreferenced in case sensitive databases
Incorrect syntax for dropping user types from SQL Server 2000 database

Changes:

Moved "Show System Databases" option from Options to Project Wizard Login step

Enhancements:

CLI switch descriptions and output
Added project name and dirty status notification into status bar
EXCEPT and INTERSECT subqueries dependency analysis is now functional on all query related methods (views, procedures, functions, expressions)

Operating System Requirements:

This product is designed to run on the following operating systems:

Windows XP
Windows 2003
Windows 2000

Additional Requirements:

Pentium Class Processor 450Mhz or highe
256MB RAM
10MB HDD space

Feedback Summary:

This Version:
Overall Rating:	Not rated (0.0)	Features:	Not rated (0.0)	Support:	Not rated (0.0)
Ease of Use:	Not rated (0.0)	Quality / Stability:	Not rated (0.0)	Price:	Not rated (0.0)