ApexSQL Clean analyzes SQL Server database objects, dependencies within the database, across databases, scripts and even applications. It recognizes all database dependencies, even those not recognized by SQL Server itself. ApexSQL Clean helps you remove unwanted objects risk free, map dependencies down to the table column level, specify database processing criteria, check or ignore the relationships for specific objects. You can also schedule unattended SQL dependency checking using the command line interface and create end-user reports to document the interdependencies in your environments. ApexSQL Clean comes with SQL Server 2014 support (all other SQL Server versions are also supported 2012, 2008, 2005), so you can analyze SQL Server 2014 object relationships and identify FileTable, sequence, search property list, column, store index, poison message, handling attribute for queues, as well as geometry and geography auto grid tessellation scheme for spatial indexes dependencies.
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.
Feature-rich relational database known for its high performance and excellent concurrency
