The database solution developers need a database to text the software or server side components like triggers or stored procedure. They can work with real data. However, this way produces a problem with critical data compromising. If the company works with subcontractors or outsourcing developers the problem becomes most important.
DTM Data Generator offers a built-in tool for data masking or scrambling. How does it work? The user selects tables and columns to be masked and the generator replaced mentioned columns to randomly generated but realistic values: card numbers, addresses, phone numbers, names, e-mails, etc. The software allows users to select target DB: new table can be saved to same or another database.
Download free demo : Professional or Enterprise.
The data generation software also offers the alternate solution for data masking. If the user already copies the production database to test one the "Update" mode is more suitable. It masks confidential data "in-place", i.e. without copy to a new table. It works faster than the first case but required a copy, as mentioned.