Can masked data be restored to its original values?

Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for SQLite, Navicat for MariaDB, Navicat for MongoDB, Navicat for Snowflake, Navicat Premium

The masked data itself cannot be restored to its original values. Access to original data depends on the masking method:

• Transfer masked data to another database: The source data is unchanged, so the original data remains intact in the source.
• Mask data in existing tables: The data is overwritten. Only a backup taken before masking can restore it.

To limit the damage if a job fails halfway, turn on Use transaction in Options so changes can be rolled back to maintain data consistency.