ApexSQL Clean versions

Analyze SQL Server dependencies and safely remove unwanted objects
Jul 2, 2018
Sep 5, 2014
Review
Sep 12, 2014
Review
Jan 17, 2014
Review
Review

What's new

v2014.0 [Sep 12, 2014]
Enhancements:
- The application now fully supports Windows SQL Azure Databases.
Fixes:
- The application does not preview all referenced columns for table with multiple triggers.
- The "Cannot connect to database 'db_name' on server 'SQL_Server_Name'" error is shown twice if connection cannot be established.
- The "Column level dependencies" option remains checked when the "Refresh" option is initiated, but the column level dependencies are not shown in the main grid.
- Double click on object in the "Parent/Children" pane does not navigate to it in the main grid.
- The "Login failed for user 'user_name'" error is encountered after trying to initiate the "Create clean-script" option for Windows SQL Azure database.
- The "Please select an object to clean" error is encountered when cleaning is initiated without proper objects selected for cleaning.
- Missing info message that dropping the objects is cancelled due the error in script execution.
- The "View DDL" window opens the script for the last opened object when double clicking the column titles in the main grid.
- The application's main grid gets expanded when the "Check/uncheck all" option is initiated from the "Results" group in the "Home" tab.
- The object tree from the "Object filter" pane gets minimized each time the object filter settings is opened or saved.
- The "Object reference not set to an instance of an object." error is encountered when working with application through CLI.
- Unnecessary and confusing title in the "Project defaults" options.
- The "Column level dependencies" option remains active even after the application restart, but the column level dependencies are not shown in the main grid.
- The "The given key was not present in the dictionary." error is encountered when selecting the object filter for all objects in the "Object explorer" panel.
- The "System.ArgumentException - The help URL'' is not valid" error is encountered when clicking the "?" character in the "Object filter" editor.
- The "Show filter row" option from the "Object selection" does not work.
- Referenced objects are not highlighted in the "View DDL" window, if initiated from the Parents/Children pane at the bottom of the main window.
- Message: "Help URL '' is not valid." is displayed in the dependency viewer options window when clicking the "?" button.
- The "Some objects in your database were not parsed successfully. This may cause problems during further work" warning dialog cannot be avoided.
- Regular expressions from the "File name patterns" option are not included in the analysis.
- The "System.NullReferenceException" error is encountered when right clicking the "Select in main grid" option on external object.
- The "Dependency type" and the "Layout type" options are not working in the "Dependency viewer" feature.
- The "Dependency viewer" window is not resizable.

Alternative downloads

Microsoft SQL Server
Microsoft SQL Server
rating

SQL Server 2022 is the most Azure-enabled release of SQL Server.

Crystal Reports
Crystal Reports
rating

Simple, Affordable, and Open BI Tools for Everyday Use

IBM SPSS Statistics
IBM SPSS Statistics
rating

You can identify customers, forecast future trends and perform analysis.

ApexSQL Complete
ApexSQL Complete
Free
rating

Improves productivity with auto-complete, snippets, text replacements and more.

ApexSQL Audit
ApexSQL Audit
rating

Audit SQL Server database data changes and undo transactions.