par ApexSQL
ApexSQL Clean by ApexSQL
Risk free delete, Impact Analysis and Graphical Dependency Viewer for SQL Server. ApexSQL Clean looks for unreferenced and unused database objects like tables and procedures and displays all relationships in a graphical, dependency viewer, using a proprietary dependency viewer that doesn't rely on SQL Server sysdepends table. With ApexSQL Clean you can dynamically browse your object dependencies using visual components like Overview and Heirarchical Dependency Treeview. Print and/or save your target diagram in a variety of graphical formats.
Have you ever wondered how many objects in your database were really referenced/used by other database objects or client applications?
Do you 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?
or maybe you are concerned about the unreliability of native sql server dependency tracking (i.e. sysdepends table still unfixed in SQL 2005)?
The answer to these questions could very well be ApexSQL Clean. It automatically detects and removes unused stored procedures, views and tables in your SQL Server Database and includes a visual dependency viewer so that you can easily check what is, or is not needed in your SQL Server Database.
ApexSQL Clean 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
PartNumbers: PC-517550-116751 517550-116751 PC-517550-116752 517550-116752 PC-517550-116753 517550-116753 PC-517550-116754 517550-116754 PC-517550-116755 517550-116755 PC-517550-116756 517550-116756 PC-517550-116757 517550-116757 PC-517550-116758 517550-116758 PC-517550-116759 517550-116759 PC-517550-116760 517550-116760 PC-517550-116761 517550-116761 PC-517550-116762 517550-116762 PC-517550-116763 517550-116763 PC-517550-116764 517550-116764 PC-517550-116765 517550-116765 PC-517550-116766 517550-116766 PC-517550-116767 517550-116767 PC-517550-116768 517550-116768 PC-517550-116769 517550-116769 PC-517550-116770 517550-116770
Publisher PartNumbers: 143480 300074605 300074613 300074614
PurchaseOptions: ApexSQL Clean 2005.09 without Support 1 Client License , ApexSQL Clean 2005.09 without Support 1 Client License per license from 3 to 5 Licenses , ApexSQL Clean 2005.09 without Support 1 Client License per license from 6 to 10 Licenses , ApexSQL Clean 2005.09 without Support 1 Client License per license from 11 to 15 Licenses , ApexSQL Clean 2005.09 without Support 1 Client License per license from 16 Licenses , ApexSQL Clean 2005.09 with 1 yr Support & Upgrades 1 Client License , ApexSQL Clean 2005.09 with 1 yr Support & Upgrades 1 Client License per license from 3 to 5 Licenses , ApexSQL Clean 2005.09 with 1 yr Support & Upgrades 1 Client License per license from 6 to 10 Licenses , ApexSQL Clean 2005.09 with 1 yr Support & Upgrades 1 Client License per license from 11 to 15 Licenses , ApexSQL Clean 2005.09 with 1 yr Support & Upgrades 1 Client License per license from 16 Licenses , ApexSQL Clean 2005.09 with 2 yr Support & Upgrades 1 Client License , ApexSQL Clean 2005.09 with 2 yr Support & Upgrades 1 Client License per license from 3 to 5 Licenses , ApexSQL Clean 2005.09 with 2 yr Support & Upgrades 1 Client License per license from 6 to 10 Licenses , ApexSQL Clean 2005.09 with 2 yr Support & Upgrades 1 Client License per license from 11 to 15 Licenses , ApexSQL Clean 2005.09 with 2 yr Support & Upgrades 1 Client License per license from 16 Licenses , ApexSQL Clean 2005.09 with 3 yr Support & Upgrades 1 Client License , ApexSQL Clean 2005.09 with 3 yr Support & Upgrades 1 Client License per license from 3 to 5 Licenses , ApexSQL Clean 2005.09 with 3 yr Support & Upgrades 1 Client License per license from 6 to 10 Licenses , ApexSQL Clean 2005.09 with 3 yr Support & Upgrades 1 Client License per license from 11 to 15 Licenses , ApexSQL Clean 2005.09 with 3 yr Support & Upgrades 1 Client License per license from 16 Licenses
Resources: Read the ApexSQL Clean help file, Read the ApexSQL End User License Agreement, Download the ApexSQL Clean 2005.09 evaluation on to your computer - Expires after 30 days
Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000
Architecture of Product: 32Bit
Compatible Containers: Microsoft SQL Server 2005, Microsoft SQL Server 2000, Microsoft SQL Server 7.0
Keywords: ApexSQL Apex SQL Database DB Reporting Report reports SQL query language Database DB Management Professional Partner ApexSQL Clean