Can Data Masking handle large tables safely?

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

Yes. The advanced options let you:

• Continue on error: Ignore errors encountered during the masking process.
• Use transaction: Run the job inside a database transaction, so changes can roll back if a major failure occurs.
• Fetch records in batches: Retrieve data in small groups to reduce memory use on very large tables. Set the batch size in Number of records per fetch.
• Update records in batches: Write masked data back in groups to improve performance and reduce log overhead. Set the batch size in Number of records per update.

To open these settings, click Options in the Data Masking wizard. The options available vary by server type.