2.2.15.1292 - Released on 6 October 2025

Features

• Added the ability to anonymize many different number types with the `RandomNumbers` dataset.

2.2.14.1183 - Released on 23 September 2025

Features

• String literals in pre or post transforms and conditional datasets can now be single quoted or double quoted.

2.2.13.1158 - Released on 15 September 2025

Fixes

• Fixed an issue with .NET runtime bundling introduced in 2.2.12.113 and 2.2.11.1089

2.2.12.1133 - Released on 15 September 2025

Features

• The names of temporary row identifiers now start with `rg_`, making them easier to identify.
• Added support for masking of temporal tables (in SQL Server). The temporal table will be masked, but the history table will be emptied. The retention period of the temporal table will also be reset.

Fixes

• Fixed an error when expressions reference a primary key column.

2.2.11.1089 - Released on 9 September 2025

Features

• Added a conditional custom dataset that allows the dataset for a column to vary based on the data in the row.
• Added ability to mask binary columns using a binary file dataset.

2.2.10.927 - Released on 21 August 2025

Features

• Added the ability to classify with data scanning and AI using the --scan-data command line parameter.

2.2.8.885 - Released on 19 August 2025

Fixes

• Fixed an issue extracting the required data for expression datasets.

2.2.4.683 - Released on 21 July 2025

Features

• Added a concat function to the pre and post masking transforms.
• Added the ability to reference other columns in the same table in pre-masking transformations. This allows for columns to be deterministic based on other columns, or combination of columns.

2.2.3.606 - Released on 15 July 2025

Features

• Added the ability to define datasets at the table level as well as globally. Table-level datasets override the global ones for that table, but global ones will be used where a table-level dataset is not defined.
• Added the ability to create datasets using an expression to use values from other columns and datasets when masking.
• Added new datasets for Domains and TopLevelDomains.

2.2.2.448 - Released on 24 June 2025

Features

• Added option to control max parallelization for masking

2.2.1.418 - Released on 23 June 2025

Features

• Added support for MariaDB. Running against MariaDB was previously possible by using --database-engine MySQL. MariaDB is now a supported value (e.g. --database-engine MariaDB).

2.2.0.388 - Released on 18 June 2025

Features

• Added the ability for pattern-based datasets to specify ranges of characters rather than just any random character.

2.1.18.342 - Released on 16 June 2025

Features

• Added the ability to defined rules to apply pre-masking and post-masking transforms to columns.

2.1.17.312 - Released on 16 June 2025

Features

• Added nullIf, nullIfEmpty and ifNull functions, and decimal, integer and date literals to pre-masking and post-masking transforms.

2.1.15.3814 - Released on 9 June 2025

Features

• Add the ability to run pre-masking and post-masking transforms on the data.
• Added a default classification rule to classify columns called 'forename' as GivenNames.
• Added a new DateVariance dataset. This works similar to the DatesOfBirth dataset in varying a date by a random number of days (up to a maximum of ±90 days).

Fixes

• Handled a false-positive classification of ethnicity columns.

2.1.14.3521 - Released on 21 May 2025

Features

• Added the ability to specify the log file location using a --log-file command line option. This can also be used to turn off the log file using --log-file none.

2.1.13.3497 - Released on 20 May 2025

Fixes

• Handled an error when the user does not have "view any definition" permissions in SQL Server.

2.1.12.3456 - Released on 12 May 2025

Features

• Added the ability to classify based on the type of a column being a number.

2.1.11.3427 - Released on 6 May 2025

• Internal library updates

2.1.8.3032 - Released on 24 March 2025

Features

• Added help links to the output when masking validation errors occur.
• Added datasets to groups to help with discoverability.

2.1.7.3006 - Released on 13 March 2025

Features

• Improved the performance of masking when running against a SQL Server database.
• Added the ability to specify the connection string via a REDGATE_ANONYMIZE_CONNECTION_STRING environment variable.
• Added the ability to use equals any and not equals any in classification rules.
• Added the ability to ignore columns from classification using a custom classification rule.

Fixes

• Added better validation of column widths when masking with pattern-based datasets.

2.1.6.2874 - Released on 27 February 2025

Features

• Added the ability to set connection and command timeouts for classification.

2.1.5.2853 - Released on 25 February 2025

Features

• Added the ability to generate a masking options file to auto-fix validation errors.
• Added the ability to manually define a unique row identifier for tables.

2.1.4.2746 - Released on 24 January 2025

Features

• Added the ability to mask more numeric data types using pattern datasets.

2.1.3.2646 - Released on 7 January 2025

Fixes

• Fixed an issue with duplicate unique constraint names.
• Fixed an issue where the total number of tables being masked was reported incorrectly.
• Ignored computed and timestamp columns in SQL Server.
• Ignored system and temporal tables in SQL Server.
• Fixed an issue with materialized views in Oracle.

2.1.2.2574 - Released on 12 December 2024

• Internal updates.

2.1.1.2551  - Released on 9 December 2024

• Internal updates.

2.1.0.2541 - Released on 5 December 2024

Fixes

• Fixed an issue with dangling constraints in Oracle.

2.0.3.3506 - Released on 27 November 2024

Fixes

• Ignored constraints on system tables.

2.0.2.2502 - Released on 26 November 2024

Fixes

• Fixed query compatibility with SQL Server instances with case sensitive collations.

2.0.1.2494 - Released on 25 November 2024

Fixes

• Fixed query compatibility with Oracle 19.

2.0.0.2317 - Released on 17 October 2024

• Renamed Anonymize.exe to rganonymize.exe

1.2.4.2032 - Released on 14 August 2024

• Internal updates.

1.2.3.1862 - Released on 12 June 2024

Fixes

• Fixed an issue where the EmptyValue dataset and NullValue dataset were querying the column data unnecessarily.

1.2.2.1852 - Released on 10 June 2024

Fixes

• Fixed an issue with the lifetime of temporary tables in SQL Server used when masking.

1.2.1.1824 - Released on 6 June 2024

Fixes

• Fixed an issue with timeouts when masking using the NullValue and EmptyValue datasets.

1.2.0.1730 - Released on 22 May 2024

Features

• Replaced the in-product date-based timebomb with a Redgate license check.

1.1.9.1641 - Released on 16 May 2024

Features

• Improved validation for dataset and datatype compatibility.
• Added support for masking exact numerics.

1.1.8.1558 - Released on 7 May 2024

• Internal updates.

1.1.6.1531 - Released on 25 April 2024

Fixes

• Fixed an issue where masking based on patterns was producing only a small number of distinct values.
• Fixed an issue where masking was generating data that was too long to fit into some columns.

1.1.5.1423 - Released on 27 March 2024

Features

• Improved error handling when masking fails.

1.1.3.1368 - Released on 12 March 2024

Features

• Added support for masking tables without primary keys.
• Switched the format of phone numbers to be US-based by default.

Fixes

• Changed the masking connection and command timeouts to 90 seconds.
• Phone number extensions are no longer classified as phone numbers.
• US states are no longer auto-classified.

1.1.2.1302 - Released on 28 February 2024

Features

• Improved realism for list-based datasets.
• Added support for using YAML for configuration and output files.
• Added support for string-based date/datetime columns.

1.0.3.1787 - Released on 16 January 2024

Features

• Improved the performance of classifying databases with large numbers of columns.
• Added the ability to create options files from the command line.
• Added the ability to preserve null values when masking. This is turned on by default.
• Changed the default behaviour for dates of birth from random date generation to variance. Existing date values will now be shifted by a random number of days (up to a maximum of 90) when masking.
• Added the ability to mask dates of births deterministically.

1.0.2.1557 - Released on 2 January 2024

Features

• Added link to documentation in the CLI help menu.
• Allowed custom datasets to be used when masking columns deterministically.
• Allowed pattern-based datasets to be used when masking columns deterministically.

Fixes

• PostgreSQL: For partitioned tables, only classify the logical "root" table, not the separate partition "child" tables. Also only read constraints from the "root" table.
• Updated links to documentation in CLI menu and errors to use more stable address.

1.0.1.1407 - Released on 15 December 2023 

Features 

• Introduced custom classification rules.
• Added help links to validation errors.
• Internal library updates

1.0.0.1182 - Released on 29 November 2023

Initial release.