ApexSQL Clean

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.

Download Trial 7.3 MB           Buy Now $374.00 USD

Software Information		System Requirements
Version:	2005.08	Windows 8/7/XP/Vista Pentium II CPU 512 MB RAM
License:	Free to try, $374.00 to buy
File Size:	7.3 MB
Screenshot :	View Screenshot
Rating :

• 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