Michael Bunger
"Thanks for the feedback Brian - I have liked the UI and support for your product the best, I should be parting with my cash very soon.."
Patrick McCarthy
Developer
JDA Software Group, Inc
Martin Schwier
Proj. Manager
WDT Datentechnik
GmbH, Germany
Alex Gadea
Sr. VP of Operations
Hostcentric Inc.
Brian Johnson
MIS Manager
FSBDC Network
Richard Dablo
Project Manager
Quest Diagnostics Clinical Trials
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
|
|
- [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
"APEX SQL Clean did work quite well for me and definitely solved a major problem for my client. I currently have it listed as "My new favorite utility" and have told several people about it."
Ron Patrick
President
NTSG (www.ntsg.com)
















