Data Masker

Data Masker for SQL Server 7.1

7.1.47 - September 13, 2024

Fixes

  • Fixed an issue in the Data Viewer and Quick Data Viewer when querying tables with columns that have special characters in them.

7.1.46 - July 16, 2024

Changes

  • The shuffle rule now uses redgate_row_id as a temporary shuffling column name instead of row_id to reduce chance
    of conflicts with customer column names.

7.1.45 - May 21, 2024

7.1.44 - April 22, 2024

Fixes

Fixes an error that occurs when using a cross DB table-to-table rule with a
Sql Server varbinary column.

7.1.43 - March 19, 2024

7.1.42 - January 30, 2024

Fixes

Fixes a SQL error that occurs when using table join in a rule's WHERE cause
if the second table has a column with the same name as the first table.

7.1.41 - January 5, 2024

Fixes

Fixed an issue where license activation window throws an error when the user clicks on the Log in button.

7.1.40 - September 27, 2023

7.1.39 - August 10, 2023

Improvements

  • Handles special characters in the database definition when editing the rule controller

7.1.38 - July 5, 2023

7.1.37 - April 25, 2023

Fixes

Fixes performance degradation issue affecting a number of rules (including those running in "legacy performance mode") introduced in 7.1.36.

7.1.36 - March 2, 2023

7.1.35 - January 11, 2023

Fixes

  • Fixes a bug reported for the Australian States dataset

7.1.34 - December 9, 2022

Improvements

  • Supports SQL Clone automated masking set runs for multiple schemas per database

Fixes

  • The tooltip on the autofix button for substitution rules with no primary key has been corrected
  • Table-to-Table rules now correctly apply 'Force ISNULLs off' option

7.1.33 - October 28, 2022

Improvements

  • Data masker now automatically creates sync manager rules for tables without a primary key when importing from a mapping file

Changes

  • Data masker no longer uses sampling in rules created when importing a mapping file

7.1.32 - October 4, 2022

Improvements

  • Allow users to apply an automatic fix for missing primary key when creating a substitution rule

7.1.31 - September 28, 2022

Fixes

  • Report an error during a masking set run if incorrect credentials are used in a controller.

7.1.30 - September 23, 2022

Improvements

  • Creating a new substitution rule now validates that the target table has the required primary key/unique index.

Fixes

  • Fixes a UI bug with the "Choose range column" form size

7.1.29 - August 3, 2022

Improvements

  • You can change the number of worker threads when running via the command-line by adding WORKER_COUNT=<number of workers 1-16> to the PARFILE.
  • Performing any import of data (from SQL Data Catalog, SQL Server Classifications, or from file) now correctly marks the masking set as needing to be saved.

7.1.28 - July 14, 2022

Improvements

  • Updated dependencies

Fixes

  • Increased the timeout for the "Import SQL Server Classifications" query

7.1.27 - June 23, 2022

Fixes

  • Fixed an issue where a timeout could occur in the default performance mode.
  • Improved how the Substitution Rule updates the rows in Legacy performance mode to help SQL Server make best use of indexes.
  • Fixed an issue that caused in-memory tables in the target database to prevent masking set creation

7.1.26 - June 16, 2022

Improvements

  • Updated dependencies

7.1.25 - May 19, 2022

Improvements

  • Updated dependencies

7.1.24 - April 22, 2022

Fixes

  • Fix the responsiveness of the dataset control in the Search & Replace Form
  • Fixed context menus

7.1.23 - March 31, 2022

Major changes

  • Upgraded to .NET 6
  • Data Masker now runs as a stand-alone executable, so it is no longer necessary to have .NET installed

Improvements

  • Simplified check for updates mechanism
  • Minor UI improvements

Fixes

  • Fixed an issue that could cause row counts to display as 0

7.1.22 - February 17, 2022

Improvements

  • The Data Masker UI can now open the mapping files (.dmmap) downloaded from SQL Data Catalog

7.1.21 - January 12, 2022

Fixes

  • Fix potential timeout when retrieving list of Databases for an instance on the Data Catalog Import form.

7.1.20 - December 17, 2021

Fixes

  • Fixed an error in the JSON Masker rule where masking a large array would reach the recursion limit

7.1.19 - November 11, 2021

Fixes

  • Fixed an issue configuring masking sets on Windows 11 systems.

7.1.18 - August 13, 2021

Fixes

  • Fixed an error when importing/exporting Masking Plans using CSV.

7.1.17 - July 19, 2021

Fixes

  • Use a temporary table to avoid deadlocks when using the v7 performance mode. This affects:
    • Row Internal Rule
    • Search and Replace Rule
    • Shuffle Rule
    • Substitution Rule

7.1.16 - July 2, 2021

Fixes

  • Fixed an error when Data Masker may not start if it fails to access the DataSet directory

7.1.15 - June 8, 2021

Fixes

  • Fix an error when exporting the Masking Plan.

7.1.14 - May 5, 2021

Fixes

  • Fixed a PAR file parsing issue when values contained '=' sign.

7.1.13 - March 15, 2021

Fixes

  • Fixed an issue where single-quotes in table/column names could prevent items being recorded in the statistics tables.
  • Fixed an issue where columns named with leading/trailing spaces caused errors while masking.

7.1.12 - March 5, 2021

Improvements

  • Change the SQL Data Catalog Importer to retrieve columns in batches. This fixes an issue where importing classifications from SQL Data Catalog would fail for some users.

7.1.11 - February 23, 2021

Improvements

  • There is a new DataSet for "Text, Alphanumeric (Random)" that will generate a random alphanumeric string of the specified length.
  • The SQL Data Catalog importer now uses the alphanumeric string dataset as the default for columns of up 5 characters.

Fixes

  • Fixed an issue with not rendering nested sync managers rules when parent sync manager was updated.

7.1.10 - February 8, 2021

Fixes

  • Fixed an issue with the index managers where all indexes with the same name could not be enabled/disabled individually, even though they are on different tables.

7.1.9 - February 8, 2021

Fixes

  • Fixed a bug where double-clicking on a masking set would always turn off legacy performance mode.

7.1.8 - February 4, 2021

Changes

  • Maintenance release

7.1.7 - December 17, 2020

Fixes

  • Fixed an error when undoing a Range Split rule.

7.1.6 - December 14, 2020

Fixes

  • Fixed the format in the "Postcodes, FR" dataset.
  • Fixed the "Edit Masking Set Notes" and "Show Notes Splashscreen Now" buttons.

7.1.5 - November 2, 2020

Improvements

  • We've made it easier to quickly generate masking sets using your classifications from SQL Data Catalog. You can now go through the entire process from the Data Masker start screen.
  • We've introduced an Import toolbar menu to simplify the import process. From here you can import from SQL Data Catalog, SQL Server or from a previously exported file.

7.1.4 - October 20, 2020

Fixes

  • We've fixed a bug where the WHERE clauses for cross DB table to table rule was not saved.
  • We've fixed a bug with the Data Catalog integration where it would get stuck on "loading".

7.1.3 - October 12, 2020

Fixes

  • We've fixed a bug where attempting to delete a rule would cause a crash in the UI.

7.1.2 - September 29, 2020

Fixes

  • Fixed a bug that caused an Application Error when applying an auto filter (right-click a column header, select Show Auto Filter)

7.1.1 - September 17, 2020

Improvements

  • We've addressed deadlock issues around statistics reporting, experienced by some of our customers.

7.1.0 - August 28, 2020

Features

  • New importer to build default rules and sensitivities from SQL Data Catalog.
  • Added a new command-line option to list the available column templates.
  • Added datasets for full US addresses, gender and photos.

Improvements

  • Improved the layout of the Misc. Setup tab.
  • Changes to the log file format.

Didn't find what you were looking for?