X

Join or Sign In

Sign in to add and modify your software

Continue with email

By joining Download.com, you agree to our Terms of Use and acknowledge the data practices in our Privacy Policy.

Apex SQL Clean

By ApexSQL Free to try

Developer's Description

ApexSQL Clean tool looks for and deletes unreferenced and unused Database objects like tables, views and procedures from within the database itself (cross-dependencies) and also from client applications (like a VS.NET project). References are created using proprietary technology that doesn't rely on SQL system tables. Apex SQL Clean includes a powerful visual Dependency viewer that converts database dependies into a graphical display. Apex SQL Clean will analyze a client whether it be VB, ASP, Delphi to determine what SQL objects are actually being used and what objects aren't. It will also analyze the database itself to see what internal references exist among SQL objects. Based on the Apex SQL Clean analysis it will generate a file of SQL drop statements to Clean your database of these useless objects. Features - 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 .cs, .vb, .frm, .aspx, .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.

Full Specifications

What's new in version 2011.01

  • Reference Graph has been deprecated
  • Regular Help button has been replaced with question mark button in title bar on all dialogs and windows
  • The following options have been moved to Project Setting form from Drops Generation wizard
    • Transactions
    • Optional Script Elements
  • Backup Original Database options have been moved from Options General to Output options step of Clean script generation wizard
  • Importing/exporting of selection profiles has been deprecated from Object Filter step of Dependency Analysis wizard
  • SQL Server object counts have been deprecated from Status Bar

General

Release January 10, 2014
Date Added January 10, 2014
Version 2011.01

Operating Systems

Operating Systems Windows 2003, Windows Vista, Windows, Windows Server 2008, Windows 7, Windows XP
Additional Requirements ADO MDAC 2.8 MSSQL Server 2012, 2008, 2005 or 2000, .NET 2.0 SP1 Run time

Popularity

Total Downloads 60
Downloads Last Week 0
Report Software

Related Software

Microsoft .NET Framework 3.5

Free
Microsoft .NET Framework 3.5

Microsoft .NET Framework 4.8

Free
Microsoft .NET Framework 4.8

Microsoft .NET Framework 4

Free
Microsoft .NET Framework 4

Microsoft Visual C++ 2005 SP1 Redistributable Package (x64)

Free
Microsoft Visual C++ 2005 SP1 Redistributable Package (x64)