ApexSQL Clean 2014.02.0149

An application that enables you to view and delete unused database objects, including tables, functions, data types and procedures
Databases contain vast amount of information spread over multiple tables, functions and objects, each holding their own fields and data.

Prolonged use can render some of these objects useless, due to obsolete fields that are not used anymore, or missing dependencies.

Clean and optimize your database objects

ApexSQL Clean is a useful software utility that comes in handy when you are confronting with cluttered tables and unwanted objects slowing your database down. It can detect and display every dependency, function and object currently available in your database, while also being able to analyze them in order to optimize the overall efficiency.

Furthermore, the application can accurately recognize interdependencies between SQL objects, as well as their relationship with external databases, applications or scripts. Thanks to this, you can preview the effects of changing or deleting certain objects, which can cause unwanted repercussions outside the database itself.

Export detailed reports and view impact analysis

ApexSQL Clean enables you to create, view and export detailed reports regarding the selected objects and their relationships. These reports also display the number of internal references for each item, the name of all the linked dependencies and the object name. The data is arranged into tables for increased accessibility and you can export it as HTML or XML documents.

Before you run the clean-up script, you can conduct a pre-impact analysis using the included analyzer, in order to determine and review the final outlook of your application and detect any functionality issues that might be caused by the deletion of certain objects. The entire script code is displayed and you can personally go through every line of it to get a better understanding of the underlying process.

Closing arguments

ApexSQL Clean is mainly aimed toward experienced users who have complete control over their database, since object deletion can have severe repercussions, especially if they are linked to outside applications.

All in all, the application behaves as expected and it enables you to properly and efficiently clean your database without losing track of dependencies and external relationships, which spares you the trouble of having to manually check for possible issues.

Reviewed by on June 20th, 2014


last updated on:
September 19th, 2014, 13:10 GMT
file size:
6.1 MB
price:
$374.00
 
developed by:
Apex SQL Tools
license type:
Trial 
operating system(s):
Windows Vista / 7 / 7 64 bit / 8 / 2003
category:
C: \ Internet \ Servers \ Database Utils

In a hurry? Add it to your Download Basket!

softpedia rating

4.5/5

user rating 1

5.0/5
 

0/5

6 Screenshots
ApexSQL Clean - You can view tables, users and all the related objects in the main window of the application.ApexSQL Clean - You can group the items by type and filter the objects by accessing the View tab.ApexSQL Clean - The right-click menu enables you to view visual dependencies and collapse groups.ApexSQL CleanApexSQL CleanApexSQL Clean
What's New in version 2014.02.0149
  • Enhancements:
  • The application now fully supports Windows SQL Azure Databases
  • Fixes:
read full changelog
 

Application description

ApexSQL Clean is a database utility that allows you to keep your database free from unused objects and procedures.Apex...

Add your review!

SUBMIT