Data Masker for SQL Server 7.1
Published 28 August 2020
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 ofrow_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.