You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 

ApexSQL Clean release notes

Release:

2016.02.0181

Date:

September 28, 2017

Fixes:

  • Dependency viewer is not showing object dependencies when connected to SQL Server 2017
  • Dependency viewer is not showing object dependencies when connected to Azure SQL Managed Instance

Release:

2016.01.0174

Date:

May 18, 2016

Enhancements:

  • SQL Server 2016 support
  • SQL Server on Amazon RDS support
  • Save project as batch file
  • The following Azure SQL Database V12 object are now fully supported:
    • Assemblies
    • Asymmetric Keys
    • Certificates
    • Defaults
    • External data sources
    • Fulltext catalogs
    • Fulltext stoplists
    • Partitions, partition functions, and partitions schemes
    • Rules
    • Search property lists
    • Sequences
    • Symmetric keys
    • XML schema collections

Fixes:

  • Parse error: "Incorrect syntax near 'For'" error is encountered when trying to analyze specific database
  • Parse error: "Incorrect syntax near '@escapeChar'" error is encountered when analyzing specific database
  • The activation key is visible in the About window
  • The application fails to process the external reference if the "Match whole word only" option is checked
  • Wrong naming of the application folder in Program Files, AppData, and Documents locations
  • CLI works even when trial period is over
  • 'Check Selected' does not work when type of object is selected
  • The Arguments field in Output options wrongly offers use of the square brackets that is wrong and doesn't work as arguments have to be set without square brackets
  • Incorrect definition for the "Clean" script
  • Missing "ApexSQL defaults" button next to the "My defaults" button while creating new project
  • Missing tooltips for the commands in the "Object selection" step of the "Create clean-script" wizard
  • The application log file is incorrectly named
  • Wrong copyright information in CLI
  • Message missing when connecting to a server in CLI
  • Incorrect version of the .NET framework is stated as needed if the .NET framework condition isn't met
  • Exported report is automatically opened
  • Save my defaults button does not work
  • Activate button in Resources is disabled after activation
  • Filter editor window goes under the Windows taskbar when adding a certain number of conditions
  • Application error when using “Category Sales for 1997” view in Northwind database.
  • Caption on Select files window is broken if directory path cannot fit in one line
  • Parse error: “Incorrect syntax near 'REMOTE_DATA_ARCHIVE'”
  • Parse error: "Incorrect syntax near 'PARQUET'"
  • The application stops working stops working when is zoomed out to the maximum in Visual dependencies window.
  • No option to set timeout limit to connect to database
  • System databases are not differentiated from user databases in the New project window
  • Bad .dll naming in ApexSQL Clean installation folder
  • No /silent switch in ApexSQL Clean CLI
  • Wrong error code when using duplicate switches
  • Wrong error code for Invalid file path in CLI
  • Wrong error code for Invalid project file in CLI
  • No error code message in CLI for Invalid activation key
  • No error code message in CLI for Trial has expired
  • Wrong error code for IO error in CLI
  • Wrong error code for Connection failed in CLI
  • Error codes missing in ApexSQL Clean CLI
  • Right click options don't work in objects selection window

Changes:

  • The application now requires Microsoft .NET framework 4.5.2
  • Windows Server 2003 is no longer supported

Known issues:

  • Browsing local servers fetches an empty list

Release:

2014.04.0162

Date:

September 04, 2015

Fixes:

  • Objects are not shown in the Main grid after analyzing a database, if the Cumulative update 7 for SQL Server 2012 Service pack 2 is installed
  • "Parse error: [Incorrect syntax near 'For']" error is encountered when trying to analyze specific database
  • "Parse error: [Incorrect syntax near '@escapeChar']" error is encountered when trying analyze specific database

Release:

2014.03.0158

Date:

March 13, 2015

Enhancements:

  • The application now supports Azure SQL Database V12
  • The user interface of the "Dependency viewer" feature was redesigned and improved

Fixes:

  • "Value cannot be null." error is encountered when the "User" and "Password" values are not specified for the SQL Server authentication in the "New project" dialog
  • SQL procedure icon is disabled all across the application
  • Drop statements for unreferenced objects in [server_name].[database_name] is not grammatically correct when one object is dropped
  • Disabled icon is used for the "View DDL" option, in context menus for any object in the application’s main window
  • The "?" button leads to the wrong web page
  • "Help URL '' is not valid" error is encountered when clicking the "?" button in the upper right corner of the main form, when the application is started
  • "Could not find a part of the path 'C:\Users\user_name\AppData\Local\ApexSQL\ApexSQLClean2014\Layouts.xml'." error is encountered when initiating the "Send logs" button, if the log file does not exist
  • "Method 'ApexSql.Clean.Properties.CliStrings.DescendantsHelp' not found." error is encountered when redirecting the help to a txt file in the CLI
  • Option titles are wrongly specified in the "Options" section
  • The "Data type" object type is not properly presented in the application main grid
  • The "x items" string in the application's main grid is not consistent with another applications
  • The "Data type" object type is not properly presented in the "Object filter" panel
  • An informative message is missing when clicking the "Select in main grid" option in the dependencies panel, in case the object is from external source
  • The "View DDL" option in the "Children" pane for children object in external database does not work
  • Right click or double click on object in the "Parents"/"Children" panes does not show an informative message if the object belongs to external source
  • The background of the "Common" and "Other" nodes are not consistent with other applications
  • The "Object filter" color is not consistent with other applications
  • The number of columns referenced is not consistent between database objects
  • The "Internal refs" column shows incorrect values
  • The application cannot be expanded over two or more displays
  • The application fails to differentiate tables with the same name but different schemas
  • "Object reference not set to an instance of an object." error is encountered when double-clicking the object in the Children pane of the main form
  • The "Filter row" feature is not consistent with another applications/add-ins
  • Missing drop down list in the filter row of the "Object selection" step in the "Create clean-script" wizard for the object names
  • Incorrect "*" mark instead of project extension in project window title
  • The "Visual dependencies" window does not have the "?" button in top right corner of the window
  • The main application window does not have "?" button in top right corner of the window
  • Invisible title of the xml options file when importing the saved file
  • The application offers to import the non-existing xml file in the "Dependency viewer" options
  • The application is enabled to define just the open delimiters for comments
  • The "External database" list is not refreshing when changing the SQL Server connection
  • The "Show filter row" option from the context menu is not synced with the same option in the "Object selection" step of the "Create clean-script" wizard
  • Inconsistent "Save" ribbon button with other applications
  • Inconsistent titles in the "Object filter editor" window for the specific object type
  • Traces remains in the "Object filter" section, when checking any of the check boxes available
  • Unable to resize the "Parents"/"Children" part of the main window
  • The "Object filter" tree expands if the "Save filter" or "Open filter" options are used
  • Inconsistent color of the "Create clean-script" button
  • 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 "Create clean-script" functionality allows you to run the script generation wizard even if at least one non-referenced object is selected
  • The "Dependencies" and "Layout" drop down menus are not wide enough in the "Dependency viewer" window
  • The Send logs functionality is incomplete when mail client is not present in the system
  • Turning off the "Filter row" option will not return basic object list
  • The "Objects tree" collapse every time when pressing the "Check all"/"Uncheck all" commands
  • Unchecking tables in the "Object filter" section and then checking them will not repopulate GUI with table objects
  • Object selection in GUI from saved project will be preserved for new project for the same database
  • "Exception of type 'System.OutOfMemoryException' was thrown." error is encountered when trying to open specific database
  • The "View DDL" option in the "Parent" pane for parent object in external database does not work
  • The "Dependency wizard" is opened on second monitor even if it turned OFF

Release:

2014.02.0149

Date:

September 10, 2014

Enhancements:

  • The application now fully supports SQL Azure

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 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" pane
  • 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

Release:

2014.01.0145

Date:

June 6, 2014

Enhancements:

  • The application now fully supports SQL Server 2014

Fixes:

  • The application tries to connect to previously connected server/database when starting a new project
  • The "External refs" column in the result grid does not show accurate number of the external references
  • Default year in the header is 2011
  • Missing warning that the object is excluded via the "Object filter" feature when trying to navigate to an object via the "Dependencies" or the "Child/Parent" panes
  • The "View DDL" option will show a body of an old stored procedure, even if the stored procedure is dropped in SQL Server Management Studio and a new one is made referencing another table
  • Missing icons in the right menu for the "Check selected" and the "Uncheck selected" functions
  • The "Login failed for user 'username'." error is encountered when selecting the "Create clean script" button
  • The "Uncheck all" function in the "Object filter" section collapses the "All objects" node
  • The "Object filter" settings are reset when a project is opened

Changes:

  • New user interface that follows Metro UI style

Release:

2011.02.0142

Date:

January 24, 2014

Enhancements:

  • The application is now FIPS compliant

Fixes:

  • The Object Browser doesn't reflect visibility state of objects excluded by the Object Filter on the graph
  • The Total references column doesn't show the summary of database references and external references
  • The 'View DDL' and the 'Select in main grid' commands do not work on columns level
  • None of the context menu commands for table columns shown in the Parents pane of the results grid doesn't work
  • Missing tooltip for the Edit button on main menu and on the Quick Access Toolbar feature
  • The Object Filter option is always expanded and can not be collapsed
  • The Export Report options dialog is missing the Title and the Defaults button
  • Inconsistent capitalization in the Object filter feature
  • Dependencies panels are not emptied when all objects are unchecked from the Object filter option
  • Old switch still exists in the CLI help
  • The Dependency viewer form is not closing on the <Esc> key
  • Inconsistent Children and Parent object names in the Dependencies panel
  • Microsoft.VC80.CRT folder is created in the installation folder
  • Same letter is used for keyboard shortcuts on the Files page of the Project dialog
  • Wrong tooltip text is used in the script generation wizard for objects grouping button
  • Main grid isn't refreshed after the script has been executed
  • Main grid object filer grouping is not remembered between application restarts
  • After Clean script is executed successfully the stats in the status bar is not updated
  • Missing proper desktop applications shortcut in Windows 8 and Windows Server 2012
  • Incomplete version is shown in the Programs and Features section in Control Panel
  • Sorting by the external references column in Main grid does not work
  • Previously grouped objects in Main greed will expand after deselecting/selecting some objects from the Object filter
  • Context menu for processing selected/checked files is missed on the Select files dialog
  • First stored procedure creation script is opened in editor in case database object type's group name in resulting grid is double clicked
  • The Object filter feature is case insensitive for the case sensitive databases
  • Non-informative error message is shown on opening the Object filter feature if the file is damaged
  • A database is re-analyzed if the Include transaction handling in drop script option is changed
  • Exporting to XML does not open applications report after saving
  • Analysis can be started with all objects excluded by the Object Filter option
  • Column level dependencies are shown in the Parents panel when the Column Level Dependencies option is set to false
  • The CLI switch "exclude" throws a parser error and doesn't generate image
  • The Column level dependencies option state is not persisted between application restarts
  • Numbers in the status bar enumerating checked/excluded files doesn't update if database objects are included/excluded for processing via Space
  • The Object name filter on the Clean script generation wizard is case sensitive for case insensitive database
  • The application is disregarding the Column Level Dependencies option settings
  • Inconsistency in UI with other applications
  • The CLI switch "exclude" doesn't exclude objects listed as switch arguments
  • The RowGUID column is shown as a Regular Column in the Column Level Dependencies option
  • Ambiguous captions in the Children and Parents pane
  • Location for database back up before dropping is not preserved between the Clean script generation wizard calls
  • SQL Server 2012 Management Studio is not enlisted in the Output option
  • The referenced/unreferenced objects are highlighted differently in Main grid and the Clean wizard

Release:

2011.01.0135

Date:

October 21, 2011

Enhancements:

  • The following new SQL Server object types are now fully supported for dependency analysis
    • Fulltext Stoplists
    • Certificates
    • Asymmetric Keys
    • Symmetric Keys
    • Roles
    • Users
    • Schemas
    • Sequences
    • Search Property Lists
    • File Tables
  • SQL Server Denali databases are now supported for dependency analysis
  • SQL Server 2005 and higher version encrypted objects can now be decrypted and analyzed (requires membership in the sysadmin server role)
  • Progress dialogs have been redesigned across the application for improved accuracy and usability
  • New Office 2007 style interface with ribbon bar, quick access toolbar, and ApexSQL Clean button has been introduced
  • New Resources ribbon bar has been introduced for quick access to Help page, Support forum, Training page, FAQs, Knowledge base, Troubleshooting, About and Get Updates dialog boxes
  • New standard Project Management dialog has been introduced
  • Project Management dialog now shows recently used projects or projects stored in any folder of choice
  • Projects can be Pinned/Un-Pined to Recent Projects list on Project Management dialog
  • Project description can be edited directly from Project Management dialog
  • 'Show on Startup' option has been added to Project Management dialog box
  • Startup Action options group has been added to Options dialog to control Project Management dialog behavior. Available choices are 'Show Project Management dialog', 'Show last opened project' and 'None'
  • Application can now be presented in 3 color schemes: Blue, Silver and Black
  • Advanced button implemented in Project wizard displays additional steps: Files and Object Filter
  • Main window Status bar has been redesigned and now shows numbers of checked rows in addition to server and database names
  • New tooltip balloon has been added to data source bar of main window Status bar
  • Options dialog has been redesigned with new Office 2007 button bar
  • The following connection options have been added to Connection step of Project wizard: 'Connection timeout', 'Execution timeout' and 'Encrypt connection'
  • Project Defaults can now be defined for newly created projects
  • Project options can now be saved as current user defaults settings
  • Project options can now be reset either to current user or to ApexSQL defaults
  • Tooltips with option description and example are shown for Project options
  • New Object Filter that allows setting filter both for particular object type and for all types has been introduced in main window
  • Object Filter allows defining filtering criteria using Filter Editor
  • Filter Editor allows to interactively create filtering expressions using Name and Schema fields
  • Filter Editor allows to filter analysis results based on 'Exclude if' or 'Include if' conditions
  • Filter Editor criteria can use the following comparison operators: 'Equal', 'Not Equal', 'Between', 'Not between', 'Contains', 'Not contains', 'Begins with', 'Ends with', 'Any of' and 'None of' and the following logical operators: 'And', 'And not', 'Or' and 'Or not'
  • Object Filter settings can be exported to or imported from file
  • Object Filter items can be grouped by SQL Object Type or by Category
  • File analysis options have been redesigned for improved usability

Fixes:

  • Application doesn't detect dependencies on Tables from SELECT statements inside Stored Procedures
  • Column is shown multiple times in Children grid when it's referenced using different case
  • Spatial indexes are displayed as unknown dependencies in Dependency Viewer's Object Browser
  • Object selection in main grid gets broken after active database is changed
  • Column dependencies are sorted in the reverse order in main grid
  • Application doesn't detect dependencies on identically named objects belonging to different schemas
  • Application doesn't detect dependencies on Tables from Triggers belonging to different schemas
  • Application doesn't detect dependencies on Assemblies from Stored Procedures
  • Application doesn't detect dependencies on Tables from ENABLE TRIGGER statements inside Stored Procedures
  • Application doesn't detect dependencies on Tables from DROP STATISTICS statements inside Stored Procedures

Changes:

  • 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

Release:

2008.03.0133

Date:

October 12, 2009

Fixes:

  • Parsing exception: Parse error: 99" error is thrown on first after main grid refresh open of Dependency Viewer
  • View DDL form doesn’t have object name in the title
  • Column dependencies aren’t displayed in Parents and Children grids in case the table/view is referenced via fully qualified name (database.owner.table)
  • "Path cannot be empty string" error is thrown after upgrading from 2005 to 2008 version of the application
  • Application doesn’t release memory after main grid refresh
  • Previously opened projects don’t appear in project history list of Manage Projects form
  • Changing "Show system databases" option on Choose Datasource step of Dependency Analysis wizard doesn't enable Save button
  • External references to spatial columns aren't shown in Dependency Viewer
  • System.OutOfMemoryException exception is thrown for large databases (>30 GB)
  • Reset button doesn't work in Dependency Analysis wizard
  • System.ArgumentException exception is thrown if project opening is cancelled
  • Unknown objects can't be deselected in Object Explorer of Dependency Viewer
  • Zooming with mouse wheel in Dependency Viewer results in black background instead of the resized diagram
  • View DDL form is opened on double click even when no object is selected in main grid
  • "Object type 'ak' is unknown" error is thrown on analysis of AdventureWorks database with any external databases
  • External references aren't marked as such in Parents and Children grids
  • Brackets enclosing server name are doubled for external references in Dependencies pane
  • System.InvalidOperationException exception is thrown when databases from different servers are analyzed consecutively
  • System.InvalidOperationException exception is thrown on deselecting objects in Drops Generation wizard with active "check" column filter
  • Application analyzes only *.cs files from Visual Studio projects/solutions regardless activate filters
  • Application doesn’t detect dependencies on tables from other tables' triggers
  • Object_types CLI switch doesn’t affect dependency diagrams
  • CLR functions aren't recognized in Dependency Viewer's Object Browser
  • Search_settings, /report_options, /script_options and /backup CLI switches don't contain information about their default values in console help output
  • [^<pattern>] regular expression doesn't exclude objects on Object Filter step of Dependency Analysis wizard
  • Application doesn’t display a warning for non-existing folders specified for "Use this Directory" option of Output Options step of Drops Generation wizard
  • System.ArgumentException exception is thrown on attempt to analyze database with SQL Server authentication and empty password
  • Added backup device isn't deleted after drop script execution
  • Backups are created with .dat extension instead of .bak
  • XML exports are always saved to default folder with default instead of user specified ones

Release:

2008.02.0132

Date:

April 1, 2009

Changes:

  • Offline help file is no longer provided and ApexSQL Clean will now directly access online help from the default system browser

Known limitations:

  • Some of Common Table Expression not supported - Example: Common Table Expression (CTE) used inside View

Release:

2008.01.0130

Date:

December 1, 2008

Enhancements:

  • Improved database parsing speed over 190% for databases with over 500 objects
  • New user interface that includes easier-to-use Project Dialog
  • Additional column level dependencies are now located. Computed columns are not located as column level dependencies
  • Services are now located as additional dependency types for ROUTE objects
  • Improvement of memory consumption and better memory management in Dependency Viewer dialog. Fixed possible application glitches related to huge memory consumption and memory consumption is lower then before up to 35%
  • CLI output in verbose mode is adjusted and enhanced to show more information about analysis process. During analysis process all steps of execution are shown with full info of analyzed objects
  • Enhanced grid filtering by adding auto complete feature to drop down list
  • In Dependencies Viewer form, filter is expanded and new filter button for Unknown objects added
  • New MSSQL2008 support. Clean is now capable of finding dependencies between following objects:
    • Table types are supported
    • Geography, Geometry, xml, hierarchy and new datetime types are supported
    • Filtered indexes and improved FullText indexes are now checked for dependencies
    • Dependencies between procedures and functions that use new table types are recognized
  • Clean now opens .axcl file type

Fixes:

  • Exception when applying Drops generation Wizard against paused SQL Server
  • Error when Analyze process invoked against paused SQL Server
  • Error saying SQL Server is still paused even if it is not
  • Exception when SQL Server is paused during Analyze process
  • Wrong help page displayed from Comments field dialog
  • Dependency Viewer Central pane is unreadable if zoom sat to 2% and Dependency Viewer reopened
  • SQL Server 2005 specific filters can be make visible when working with SQL Server 2000 databases
  • Analyze process progress info dialog can be maximized by double-clicking caption bar
  • Server Selection Procedure help file page button captions are outdated. Changes made in version 126 are omitted
  • Drops Generation Wizard, General Options help page is outdated ("General options" label)
  • Managing Script Help page cannot be displayed
  • When clicking on a column, the object list appears to filter down to only objects in the original database that reference the column
  • Saved project's name displaying empty in existing projects grid
  • Column References incomplete if column referenced from other databases
  • DB create script contains more than one CREATE statement error

Changes:

  • HTML report file after generation (Report.html) is now stored in My Documents\ApexSQL\ApexSQLClean folder instead of Application folder
  • Dependencies pane now can be closed and opened via corresponding menu item in Main form’s Main menu -> View group
  • Project window is now resizable with appropriate sign in the form's bottom right corner
  • Default Folder for projects is changed to be MyDocuments/ApexSQL/ApexSQLClean2008 instead of application folder

Known limitations:

  • Some of Common Table Expression not supported - Example: Common Table Expression (CTE) used inside View