How do I mask data while transferring it to another database?

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

This method masks data during the transfer, so the target tables only receive protected data. The source data stays unchanged.

1. In the main window, choose Tools > Data Masking.
2. Select Transfer masked data to another database and click Next.
3. Choose the source and target connections, databases and schemas.
4. Optional: click Options, set the advanced settings and click OK.
5. Select the objects to transfer, set the transfer mode and click Next.
6. Choose the columns that need protection and click Next.
7. Assign a masking technique to each selected column and click Next.
8. Review your settings and click Start.