ApexSQL Mask release notes

Fixes:

• 204212: "Masked data exported successfully" message is shown when the mask is exported in the XML output file even though the XML file is not created
• 171036: "Selected column is not supported by generator" error is encountered when applying the predefined generators supported by the column’s data type
• 204329: "File 'C:\User\%user%\ApexSQL\ApexSQL Mask\Export\script.sql doesn't exist" error is encountered when opening the created single script that includes the substitution mask for the Use original type without checking the Shuffle option in the integrated editor
• 160832: Mask not supported by the integer data type can be applied to a column from the column’s right-click context menu in the main grid
• 164231: Mask not supported by the datetime data type can be applied to a column from the column’s right-click context menu in the main grid
• 164236: The original data is shown in the Masked column of the Preview section for a column after the created substitution mask is applied using the right-click context menu in the main grid
• 171716: The application closes when the regular expression is typed in the Create substitution mask window for the regular expression type
• 200775: "Cannot connect to '(local)'" message is shown when trying to connect to a local SQL Server using (local) as server name on a machine where only one SQL Server instance is installed
• 201618: The application goes into not responding state when the Refresh option from the column’s right-click context menu in the main or classified grid is clicked
• 204229: All columns present in the main grid are checked after the Manage mask window is closed
• 204320: Wrong data is shown in the Masked column of the Preview section when the dynamic data mask created using the custom text type is applied to a column
• 204321: Wrong data is shown in the Masked column of the Preview section when the dynamic data mask created using the Email type is applied to a column
• 204391: The predefined masks will not be applied to the same sensitive data columns when the Automatically scan for sensitive data option in the Options window is checked and the Refresh button is clicked
• 205188: “Target column is not supported by selected generator” message is shown in the Apply to columns dialog when trying to apply the Personal – Salary predefined generator to a column that not contains the ”salary” in the name
• 207789: ''Error encountered and application needs to be closed'' error is encountered when the Import button is clicked under the Hide original data tab of the Manage masks window with the previously selected Classified grid
• 208614: The type of the user-created substitution mask is changed to the Use original type after the Edit mask button is clicked for the second time in the Manage masks window
• 208729: Encrypted password will be saved in the project file even though the Remember password option in the Connect to SQL Server dialog is unchecked
• 208730: Changes made against the created substitution mask are not present in the created single mask script
• 208733: The status of the Null option for the substitution mask when the Specific value type is chosen on a column level is not remembered
• 208742: Excessive columns are shown in the Apply to columns window and the Drop dynamic data masks statements are written in the mask script after editing the dynamic data mask
• 208748: The redaction mask is not present in the created mask script when the substitution mask is applied as well
• 208755: “Target column is not supported by selected generator” message is shown when trying to edit the created mask by applying any other supported predefined generator to a selected column
• 208757: The dynamic mask will not be present in the mask script if it was previously edited
• 208760: The column’s data is shown as original in the Masked column of the Preview section or the created mask script when the substitution mask created using the AutoIndustry generator is applied
• 208762: The column’s data is not masked if the dynamic data mask previously edited is applied against it and the Update database button in the Process masks dialog is clicked
• 208764: The status of the Null option for the substitution mask when the Specific value type is chosen on a row level is not remembered
• 208765: The column’s data is not masked if the different dynamic data mask is applied to the same column and the Update database button in the Process masks dialog is clicked
• 208771: The columns from different tables but with the same names are recognized as one column in the Apply to columns dialog
• 208773: "Error encountered and application needs to be closed" error is encountered when the Create single script button in the Process masks dialog is clicked and no mask is applied to any column
• 208774: The original data is shown in the Masked column of the Preview section and created single mask script after the substitution mask created using the FoodAndBeverage predefined generator is applied to a column
• 208777: "Error encountered and application needs to be closed" error is encountered when the type of the created substitution mask is changed and the OK button is clicked in the Create substitution mask is clicked
• 208778: "Error encountered and application needs to be closed" error is encountered when a wrong SQL script path is entered in the Use this script field in the Create substitution mask window
• 208783: “Error encountered and application needs to be closed” error is encountered when the predefined generator used for creating a substitution mask is changed to the Personal – Full name generator and the OK button is clicked in the Create substitution mask window
• 208792: Wrong information about the updated columns is shown in the result file after the database update is finished and the Export result button is clicked in the View summary window
• 208793: Wrong information about the updated columns is shown in the report file after the database update is finished and the Create report button is clicked in the View summary window
• 208794: The created redaction masks previously saved as a part of the project file are duplicated after the project file is loaded
• 208834: ''Selected column is not supported by a generator'' message is shown when the predefined generator is chosen in the Select generator dialog for a column that does not contain a generator specific word in the name
• 208898: The generated mask data not includes the null values in the Masked column of the Preview section even though the Include nulls option is checked in the Create redaction mask window
• 208899: The generated mask data in the Masked column of the Preview section do not include set wildcard options for a created redaction mask
• 208915: Data masked with the redaction mask is not present in the exported file no matter what output file format is chosen
• 208916: "File 'C:\User\%user%\ApexSQL\ApexSQL Mask\Export\script.sql doesn't exist" error is encountered when opening the created single script that includes a substitution mask previously edited by click on the Edit mask column’s right-click context menu in the main grid
• 208918: Additional table containing the checked columns in the name will be listed in the main grid after the created dynamic data mask is applied to that column
• 208920: The applied redaction mask is not present in the created mask script
• 208924: Only the masked data for the first checked column will be exported in the CSV output file format when additional columns with the same name but from different tables are checked as well
• 208912: The applied redaction mask is not present under the Details tab in the Process masks window
• 211133: ''Error encountered and application needs to be closed'' error is encountered when any listed column is clicked in the main grid for the SQL Server 2014 version and earlier if the Automatically scan for sensitive data option is enabled

Enhancements

• The Trust certificate option is added under the Connection options dialog

Fixes:

• 197760: The predefined data masks will be added to all sensitive data columns when the Refresh button under the Home tab is clicked even though the Automatically scan for sensitive data option in the Options window is not checked
• 199044: The application goes in the not responding state after the Refresh button under the Home tab is clicked
• 199434: Columns previously masked with the dynamic data masks are not marked as masked in the Apply to columns dialog
• 199436: "Error is encountered and application needs to be closed" error is encountered when the Process button in the Home tab is clicked after the dynamic data masks are imported
• 199443: The Drop dynamic data masks statements are present in the script for every dynamic data mask used
• 204312: The user permission statements are missing from the mask script when the dynamic data masks are used
• 204314: The Update statements are present in the mask script for every column masked with the dynamic data mask
• 204392: "Selected columns must have masking rules to export masked data" message is shown when the Export button is clicked in the CSV dialog if the Use original mask sub-type is used for data masking
• 204393: "Selected columns must have masking rules to export masked data" message is shown when the Export button is clicked in the Excel dialog if the Use original mask sub-type is used for data masking
• 204394: The Use original mask sub-type is added to all sensitive data columns when the Refresh button in the Home tab is clicked after the Automatically scan for sensitive data option is checked for previously loaded database
• 204398: "Selected columns must have masking rules to export masked data" message is shown when the Export button is clicked in the JSON dialog if the Use original mask sub-type is used for data masking
• 204399: "Selected columns must have masking rules to export masked data" message is shown when the Export button is clicked in the XML dialog if the Use original mask sub-type is used for data masking
• 205913: The Type options in the Create filter and Edit filter windows are not visible
• 206215: The data previously masked with the redaction mask and saved to a project file will be shown as original in the Masked column of the Preview section after the project is reopened
• 206216: The Random mask sub-type will be added to a column previously saved with the Use original mask sub-type when the project is re-opened
• 207790: The Substitution row mask replaces all data in the specified column
• 207791: The Alter table statements for disabling constraints, delete, insert and update triggers are missing from the mask script even though the Disable options under the Generation tab of the Options window are checked

Fixes:

• 180560: SQL query generator masks are not displayed correctly when the Refresh button is clicked from the Home tab
• 183287: Redaction rule is not applied when opting for Refresh button in the Home tab
• 191985: Editing “Use original mask” in “Create substitution window” display incorrect mask type
• 197208: The Zip Code sensitive data in columns are automatically masked with data created with the Use original generator instead of data that is created by the predefined generator
• 197757: User authentication for remote SQL Server connection is unsuccessful after the project file in use is saved more than once
• 197768: “String or binary data would be truncated” error is encountered when the Specific value type is longer than column data type
• 199092: Automatic scan for sensitive data is performed on Refresh button when it is disabled in the Options
• 199132: “Selected columns must have masking rules to export masked data” info message is shown when exporting in XML, JSON, CSV, and Excel output file format column which is masked with Hide original data
• 199255: “Provided generator absent in availability list” error is encountered when updating existing mask using the Full name substitution mask
• 199272: “Could not load file or assembly 'Microsoft.SqlServer.Types” error is encountered when using 2020 R4 and newer versions of the application from the command-line interface (CLI)
• 201343: The newly created filter is not applied to the selected column in the Manage data classification filters
• 201344: The edited filter is not applied to the selected column in the Manage data classification filters
• 202880: Filters are applied even if they are unchecked in the Manage data classification filters window after the Refresh button is clicked from the Home tab
• 204395: The application is forcibly closed when using a .xml file to make a substitution mask with external source generator
• 204397: The application is forcibly closed when creating a regular expression mask using special characters
• 204545: The application is forcibly closed when editing and applying masks to columns after creating a masking script using the Create script per table option from the Manage masks window

Fixes:

• 200277: Unable to establish a connection to SQL Server instances from the Connect to SQL Server window when the application is upgraded from 2020 R3 to 2020 R4 version
• 200391: Unable to open a previously saved project if it has been saved using the 2020 R3 or older version of the application
• 200833: "One or more errors occurred." error is encountered in the Command prompt when trying to mask data in the database using an automation script of a project that runs without errors in the main application

Enhancements:

• Create script per table option is added as the third mask process option in the Process masks window

Fixes:

• 197150: "Object reference not set to an instance of an object" error is encountered when opening previously saved project and clicking on the column which is masked with the regular expression generator
• 197147: "Path cannot be null. Parameter name: path" error is encountered when opening previously saved project and clicking on the column which is masked with a CSV file type
• 196640: The newly added masks are not saved when saving masks in already opened project
• 198852: Unable to connect to Azure SQL Database when the Automatically scan for sensitive data option is checked under the General tab in the Option window

Enhancements:

• Dynamic data masking is added under the Hide original data tab of the Manage masks window

Fixes:

• 187013: "Select column is not supported by a generator" message is shown when trying to add the char date type column to a newly created substitution mask with the first name predefined generator
• 183303: "Object reference not set to an instance of an object" error is encountered when creating the mask script for a selected column with the null value for a data generator
• 190349: "Length cannot be less than zero" error is encountered when trying to connect to a selected database that contains a column with the max length data type in the Connect to SQL Server window

Enhancements:

• External data source can be used to mask sensitive data
• Export masked data to an external data source
• Mask data in the SQL Server graph tables

Fixes:

• "Cannot update a timestamp column" error is encountered when the masking process is finished even if the column that has the timestamp data type is not included in the masking process
• "One or more errors occurred" error is encountered after the mask script is created for a column that is masked using the Substitution mask and Random generator
• Ignored columns and SQL objects are present in the created SQL script
• Tables with identity columns cannot be masked
• Project column settings are not saved when only one column is checked

Enhancements:

• Use SQL value to mask data
• Parallel mask execution
• Application telemetry now collects anonymous data on the use and performance of applications and application components
• New ApexSQL Updater allows users to configure advanced updating settings of all installed ApexSQL products

Fixes:

• "Invalid column name" message is shown when the masked process from the Home ribbon is started

Fixes:

• The backup of the original database before data masking option does not save the backup of original SQL database before masking process is started
• Custom filter added from the Manage data classification filters window is removed from an assigned SQL objects when the Refresh button is used twice in the main grid
• "Object reference not set to an instance of an object" error is encountered when the customer filter is added under the Manage data classification filters window and the SQL database in the main grid is refreshed

Enhancements:

• Edit predefined filters

Fixes:

• "Object reference not set to an instance of an object" error is encountered when importing file to the Redaction rule
• SQL data is not masked when masking process is finished using the automation script
• SQL data is not masked when SQL Server authentication is used in the automation script
• "Invalid object name 'dbo.CO_stg_ConstructionPossessionDate'" error is encountered when creating substitution mask
• Multi selection is not working in the Apply to the columns dialog
• The Save the project dialog does not show when close a project by pressing the Close (X) button on the top right corner of the application
• "Application ApexSQL Mask already running. Only one instance is allowed" message is shown when the automation script is running
• The dialog is shown in wrong order when the filter with the same name is created
• Browse button under the Find what field in the Create redaction mask dialog open slow when it is used for the first time
• The predefined generators are shown two times under the Manage masks dialog "Could not load file or assembly 'Microsoft.IdentityModel.Clients.ActiveDirectory,Version=4.5.1.0'" error is encountered when using Active Directory Universal with MFA support
• "C:\Users\PC-name\Desktop\AutomationScript_2019064_12-00-32.45.ps1 cannot be loaded" error is encountered when starting the PowerShell script from the desktop location
• Classified columns are all unchecked when only selected columns are unchecked in the Manage masks dialog
• "Selected file cannot be imported as redaction mask" message is shown even if importing file is canceled under the Manage masks dialog
• "Invalid column name 'TSTAMP'" error is encountered when saved SQL script is opened in the default editor
• "Invalid column name 'TS'" error is encountered when saved SQL script is opened in the default editor

Changes:

• Software Transaction Agreement is added as a new step in the installation wizard and updated in accordance with https://www.quest.com/legal/sta.aspx

Fixes:

• "Unable to cast object of type varchar to XML" error is encountered when trying to connect to a database that contains table with the XML data type
• The original data in the rows is not completely masked due to invalid WHERE clause syntax when masking process is finished
• "Could not load file or assembly" error is encountered when connecting to a server with the Active Directory - Universal with MFA support
• "Object reference not set to an instance of an object" error is encountered when the OK button is clicked in the Connection options dialog after changing value for timeout options

Features:

• High DPI and 4K resolution support
• Supports SQL Server 2005 or higher, Azure SQL Database and Amazon RDS for SQL Server
• Leverage 220+ pre-defined data masks
• Automatic sensitive data classification
• Mask data at column and/or row level
• Overwrite the original database or create the masking script
• View full database masking job summary
• Utilize 55+ built in data classification filters
• View before-and-after masked data
• Create and edit sensitive data masks
• Import and export masks and filters
• Create and edit data classification filters
• Choose from substitution or redaction masks
• Visualize database-level data masking profile
• Sensitive data masking
• CLI support for executing project files [/pr]
• Save project as automation script
• GUI themes