Risk free delete, Impact Analysis and Graphical Dependency Viewer for SQL Server

Ever wonder how many objects in your database were really referenced/used by other database objects or client applications? 

Want to view database dependencies visually even across databases and servers and/or export to xml/html for additional analysis. 

Are you interested in column level dependencies for pre-impact analysis? 

Concerned about the unreliability of native sql server dependency tracking (i.e. sysdepends table still unfixed in SQL 2005)?

ApexSQL Clean looks for unreferenced and unused database objects like tables and procedures and displays all relationship in a powerful graphical, dependency viewer, using a proprietary dependency viewer that doesn't rely on SQL Server sysdepends table.  Dynamically browse your object dependencies using powerful visual components like Overview and Heirarchical Dependency Treeview.  Print and/or save your target diagram in a variety of graphical formats.

Product Information ApexSQL Clean Product Overview ApexSQL Clean News ApexSQL Clean Datasheet

ApexSQL Clean FAQs ApexSQL Clean Help File ApexSQL Clean Knowledge Base

Screen Shots

Features

• [NEW] Column level dependencies
• [NEW] Proprietary Dependency parsing algorithms for SQL 7, 2000 and 2005 that provide accurate dependency analysis vs native SQL Server methods that use sysdepends table
• [NEW] SQL Server 2005 Support
• [NEW] New Auto-update feature
• [NEW] 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

What People are Saying