If database object bloat is the problem, ApexSQL Clean is the solution. Your SQL Server Database
may have many stored procedures, tables, defaults, views etc that aren't being used anymore but
unless you determine which of your objects are truly unreferenced you will be stuck with them forever,
or risk breaking your database if you delete the wrong object. ApexSQL Clean will analyze a client whether
it be C#, ASP.NET, 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 forever.
ApexSQL Clean also provides a powerful Graphical Dependency viewer, leveraging proprietary
dependency analysis algorithms that don't rely on unreliable native SQL dependency processing,
that allows you to visualize the interdependencies between database objects,
including external references to other databases.
We hope you will enjoy the analysis, presentation and exporting capabilities of this powerful tool
and it becomes another valued component in your SQL toolkit.
- Pentium II CPU
- 256 MB RAM
|License:||Free to try, $249.00 to buy|
Key Features of ApexSQL Clean:
- Column level dependencies
- Proprietary Dependency parsing
algorithms for SQL 7, 2000 and 2005 that provide accurate
dependency analysis vs native SQL Server methods that use sysdepends table
- SQL Server 2005 Support
- New Auto-update feature
- Regular expression object filter
- Graphical Dependency Viewer
- 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 .aspx, .cs, .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.
- Unicode support
| RELATED SOFTWARE DOWNLOADS FOR APEXSQL CLEAN
- ApexSQL Diff
s a high speed database comparison tool that analyzes the differences in tables, proc
- ApexSQL Doc
is a powerful tool to document your sql server database into Compiled Help or HTML documentation.
- ApexSQL Edit
is a powerful IDE especially designed for advanced SQL Server developers including integration with source control, Intelliprompt..
- ApexSQL Log
can audit SQL Server and Recover Lost Data that analyzes SQL Server's own transaction log to display information.
- ApexSQL Report
is a data driven, web reporting solution for Microsoft SQL Server.
- ApexSQL Script
is a SQL tool that converts Databases into scripts, .net EXE's, deployment packages or into source control.
- ApexSQL Audit
ApexSQL Log is a SQL database auditing tool that analyzes SQL Server's own Transaction Log to display information on data.
- Visual Options Analyzer
is a powerful analysis tool for development, testing, and application of stock and options strategies
- Sharepricer - stock analysis tool
is an easy-to-use, but flexible stock analysis tool
- Reportizer - Database Reporting Software
Easy creating, modifying and printing database reports. Allow to manage report collections
- Dataodyssey Express
is Simple and powerful means for creating a Knowledge-Discovery solutions
- Database Tour Pro 5
is Database managing and reporting tool;includes SQL tool, reporting tool, data converting, exporting, importing utilities and much more
- Database Reporting ActiveX Control
is an abstract solution and hence general solution to all reporting problems.