ApexSQL Clean 2005.07

ApexSQL Clean 2005.07 Screenshot ApexSQL Clean looks for and deletes unreferenced and unused Database objects like tables, views and procedures.

Developer:   Apex SQL tools
      software by Apex SQL tools →
Price:  249.00  buy →
License:   Trial
File size:   0K
Language:   
OS:   Windows Vista (?)
Rating:   0 /5 (0 votes)

ApexSQL Clean looks for and deletes unreferenced and unused Database objects like tables, views and procedures.

If database object bloat is the problem, ApexSQL Clean is the solution. Your database may have many stored procedures, tables and views that aren't being used anymore but unless you determine which of your objects fall into this category you will be stuck with them forever.

ApexSQL Clean will analyze a client whether it be ASP, Delphi, VB etc 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 this 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 .frm, .asp, .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.

Requirements
  • MDAC 2.7(ADO 2.7) MSSQL Server v7, 2 or 2005, .NET 1.1 Run time

    Limitations
  • 30 days trial

    tags apexsql clean  interface shows  search pattern  object will  user defined  sql objects  tables views  your database  being used  

    ApexSQL Clean 2005.07 screenshot


    Download ApexSQL Clean 2005.07

     Download ApexSQL Clean 2005.07

    Purchase:  Buy ApexSQL Clean 2005.07


    Authors software

    ApexSQL Clean 2005.07 ApexSQL Clean 2005.07
    Apex SQL tools

    ApexSQL Clean looks for and deletes unreferenced and unused Database objects like tables, views and procedures.

    ApexSQL Code 2005.05 ApexSQL Code 2005.05
    Apex SQL tools

    ApexSQL Code is a Rapid Application Development (RAD) Code Generation tool for Microsoft® SQL Server© 7 or 2 that enables you to automatically generate thousands of lines of perfect ASP, VB, C#, SQL (and more) code in just seconds The key feature of ApexSQL Code is Template based code generation that will allow users to configure custom code patterns automated with the scripting language of your choice, VBScript or JScript.

    ApexSQL Script 2005.04 ApexSQL Script 2005.04
    Apex SQL tools

    ApexSQL Script creates insert scripts from any Microsoft® SQL Server© 7 or 2 database that can be archived, emailed, checked into source control, run against another database etc.

    Apex SQL Diff 2005.11 Apex SQL Diff 2005.11
    Apex SQL tools

    Apex SQL Diff is a server based, high speed database comparison tool that will analyze the differences in tables, procedures, views, users etc between two Microsoft SQL Server databases in seconds.

    Apex SQL Log 2005.04 Apex SQL Log 2005.04
    Apex SQL tools

    ApexSQL Log is a powerful SQL database auditing tool that analyzes SQL Server's own Transaction Log to display information on data and soon .

    Similar software

    ApexSQL Clean 2005.07 ApexSQL Clean 2005.07
    Apex SQL tools

    ApexSQL Clean looks for and deletes unreferenced and unused Database objects like tables, views and procedures.

    SQLClean 2.3.76 SQLClean 2.3.76
    Lockwood Technical Services, I

    If database object bloat is the problem, SQLClean is the solution.

    Softinabox Script Engine 0.3.0 Build 52 (Beta 3) Softinabox Script Engine 0.3.0 Build 52 (Beta 3)
    Softinabox

    Softinabox Script Engine for Microsoft SQL Server 2000 is a powerful tool that enables you to document any existing database structure and/or data by generating one SQL script.

    SQL Server Tools 1.0 SQL Server Tools 1.0
    Redei Enterprises

    Enumerates all SQL Server objects for a selected database, writes the scripts that create the objects.

    SQL Bloodhound 1.2 SQL Bloodhound 1.2
    The Code Syndicate

    The Code Syndicate's SQL Bloodhound is a useful, simple and powerful database object search tool for SQL Server.

    Apex SQL Diff 2005.11 Apex SQL Diff 2005.11
    Apex SQL tools

    Apex SQL Diff is a server based, high speed database comparison tool that will analyze the differences in tables, procedures, views, users etc between two Microsoft SQL Server databases in seconds.

    microOLAP Database Designer for PostgreSQL 1.2.8 microOLAP Database Designer for PostgreSQL 1.2.8
    microOLAP Technologies LTD

    Database Designer for PostgreSQL is an easy and useful CASE tool with intuitive graphical interface which allows you to build a clear and effective database structure visually, see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects.

    SqlSpec 6.5 SqlSpec 6.5
    ElsaSoft

    SqlSpec is an application for generating SQL Database specs.

    ApexSQL Script 2005.04 ApexSQL Script 2005.04
    Apex SQL tools

    ApexSQL Script creates insert scripts from any Microsoft® SQL Server© 7 or 2 database that can be archived, emailed, checked into source control, run against another database etc.

    Database Voyager 1.5 Database Voyager 1.5
    Elkom Expert

    Database Voyager is a powerful utility with an intuitive graphical user interface to Oracle databases.

    Other software in this category

    kaztrix DataBuilder 1.0 kaztrix DataBuilder 1.0
    Kaztrix Software

    KazTrix DataBuilder 1.

    ConversionTool 4.2.2 ConversionTool 4.2.2
    Keper Consultancy

    The conversiontool is a tool which easily converts a MS Access database to a SQL Server database.

    SQLClean 2.3.76 SQLClean 2.3.76
    Lockwood Technical Services, I

    If database object bloat is the problem, SQLClean is the solution.

    XL Report Builder 2.1.4 XL Report Builder 2.1.4
    Desktop Software

    Knowledge is Power.

    DB Navigator 3.0.0 DB Navigator 3.0.0
    Desktop Software

    DB Navigator is an application for the work with database tables of the DBF format.