| |
|
|
| Apex SQL Clean tool looks for and deletes unreferenced and unused Database objects like tables, views and procedures. If database object bloat is the problem, Apex SQL Apex SQL Clean is the solution. |
| Other software from this author: | - Apex SQL Audit 3.4 — Apex SQL Audit proves a comprehensive, enterprise level active data auditing tool for Microsoft® SQL Server© 7 or 2000 Database auditing unmatched on the market today.
- Apex SQL Log 2005.01 — Apex SQL Log is a powerful SQL database auditing tool that analyzes SQL Server's own Transaction Log to display information on data and structural changes.
- Apex SQL Script 3.93 — Apex SQL Script© creates insert scripts from any Microsoft® SQL Server© 7 or 2000 database that can be archived, emailed, checked into source control, run against another database etc.
| | Show all software from this author |
Description:
Apex SQL Clean tool looks for and deletes unreferenced and unused Database objects like tables, views and procedures. If database object bloat is the problem, Apex SQL Apex SQL Clean tool 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 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 .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. | System Requirements:
MDAC 2.6(ADO 2.6) MSSQL Server v7 or 2000 MS SQLDMO Object Library (SQLDMO.DLL) | Change Info:
new product | | Apex SQL Clean 3.1 Download from apexsql.com |
| Similar software: | - Apex SQL Code 3.1 — Apex SQL Code is a Rapid Application Development (RAD) Code Generation tool for Microsoft® SQL Server© 7 or 2000 that enables you to automatically generate thousands of lines of perfect ASP, VB, C#, SQL (and more) code in just seconds.
- Apex SQL Diff 2.47 — Apex SQL Diff is a server based, high speed database comparison tool that will compare the differences in tables, procedures, views, users etc between two Microsoft® SQL Server© databases in seconds.
| | Find all software similar on Apex SQL Clean 3.1 |
|
