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.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.