ApexSQL Clean 2.8.90

Program Specifications

Download ApexSQL Clean
ApexSQL Clean 2.8.90
  View more screenshots
Version: 2.8.90
Size: 3.70 MB
Publisher: Apex SQL tools
Date Added:
License [?]: Shareware (USD$149.00 to buy)
Operating System: WinXP, WinNT, WinME, Win98, Win95, Win2000
Requirements: MDAC 2.6(ADO 2.6) MSSQL Server v7 or 2000 MS SQLDMO Object Library (SQLDMO.DLL)
Download Links: Download ApexSQL Clean
BumperSoft Editor's Review Status:

Publisher's Description of ApexSQL Clean

" Looks for and deletes unreferenced and unused Database objects. "
- From Apex SQL tools

ApexSQL Clean looks for and deletes unreferenced and unused Database objects like tables, views and procedures.

If database object bloat is the problem, ApexSQL ApexSQL 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.

ApexSQL 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.

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 .frm, .asp, .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.

Limitations in downloadable version

14-day trial

Share ApexSQL Clean with Friends


Tags

sql   |  clean   |  database   |  ms   |  server   |  tool   |  tables   |  views   |  procedures   |  apexsql   |  objects   

RELATED DOWNLOADS
(Databases and Networks)

Visual SQL-Designer 4.00
A program for easy visual constructing hard SQL-query for any database and write it.
DBConvert for MS Access & MySQL 7.0.1
Bi-directional effective conversion tool for MS Access and MySQL databases.
DB SynchroComp 3.4.0
Detects the differences between two SQL database schemas and synchronizes them.
Access Autopilot 1.1.35
Schedule automatic backup, compact and archive of Access databases.
WEEK'S TOP DOWNLOADS
(All Categories)

1. WinPcap
2. EMS DBISAM Manager
3. Macromedia FreeHand MX
4. Antiquarium
5. TypingMaster Pro
6. DBF Viewer 2000
7. Free Hex Editor
8. Uni2Me
9. MiKTeX
10. Cygwin

More information