ApexSQL Mask release notes

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