You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

Tools for Security and Compliance ApexSQL Security and Compliance Toolkit for SQL Server
Tools for DBAs and Operations Engineers ApexSQL Operations Toolkit for SQL Server
Tools for SQL Server Professionals ApexSQL Fundamentals Toolkit for SQL Server
Tools for Developers and DevOps Engineers ApexSQL DevOps Toolkit for SQL Server
Tools for MySQL Professionals ApexSQL Fundamentals Toolkit for MySQL Server
Spotlight Cloud hosted SQL Server monitoring and diagnostics
LiteSpeed High-speed SQL Server backup, compression and restore
 

ApexSQL Mask release notes

Release:

2020.06.0286

Date:

April 13, 2021

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

Release:

2020.05.0279

Date:

January 20, 2021

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

Release:

2020.04.0268

Date:

December 30, 2020

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

Release:

2020.03.0252

Date:

November 02, 2020

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

Release:

2020.02.0222

Date:

May 26, 2020

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

Release:

2020.01.0192

Date:

April 30, 2020

Enhancements:

Fixes:

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

Release:

2019.04.0169

Date:

February 24, 2020

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

Release:

2019.03.0159

Date:

October 17, 2019

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

Release:

2019.02.0097

Date:

June 21, 2019

Changes:


Release:

2019.02.0086

Date:

April 18, 2019

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

Release:

2019.01.0070

Date:

March 19, 2019

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

    © 2021 Quest Software Inc. ALL RIGHTS RESERVED.   |   GDPR   |   Terms of Use   |   Privacy