ApexSQL Clean is a SQL Server development tool that looks for unreferenced and unused database objects such as tables and procedures and displays them graphically.
ApexSQL Clean/2005.09 provides all the relationships in a graphical, dependency viewer using a proprietary dependency viewer that doesn't rely on a SQL Server sysdepends table. Dynamically browse your object dependencies using visual components, like Overview and Hierarchical Dependency Treeview. Print and/or save your target diagram in a variety of graphical formats.
ApexSQL Clean new features include:
Automatically detects and removes unused stored procedures, views and tables in a SQL Server database. The tool includes a powerful visual dependency viewer.
Proprietary Dependency parsing algorithms for SQL 7.0, 2000 and 2005 that provide accurate dependency analysis versus native SQL Server methods that use a sysdepends table.
Regular expression object filter.
New auto-update feature.
SQL Server 2005 support.
Column level dependencies.
System requirements: Software prerequisites -- Microsoft SQL Server versions 7.0, 2000 or 2005. Required components not included with installation --
Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater,
Microsoft .NET Framework 2.0. Compatible operating systems -- Windows 2000, Windows XP, Windows 2003, Windows Vista. Compatible with 64-bit OS versions, Pentium-class processor 600 MHz or higher, 512 MB RAM (256 MB minimum), 10 MB free disk space (20 MB preferred).
Pricing: ApexSQL Clean + no maintenance $249, 1 license $249, 2-4 licenses $199, 5-9 licenses $174, 10+ licenses $149, site license $1,643. ApexSQL Clean + 1 yr. maintenance $311, 1 license $311, 2-4 licenses $249, 5-9 licenses $218, 10+ licenses $187, site license $2,053. ApexSQL Clean + 2 yr. maintenance $349, 1 license $349, 2-4 licenses $279, 5-9 licenses $244, 10+ licenses $209, site license $2,303. ApexSQL Clean + 3 yr. maintenance $361, 1 license $361, 2-4 licenses $289, 5-9 licenses $253, 10+ licenses $217, site license $2,383.
