Redgate Test Data Manager

Anonymize command-line reference - classify

Automatically discover which columns of a database contain PII (personally identifiable information).

rganonymize classify 
  --database-engine SqlServer 
  --connection-string "[connection string]"
  --classification-file classification.json
OptionRequired?Notes
--database-engine (tick)

The type of the database to classify.

Must be one of:

  • SqlServer
  • PostgreSql
  • MySql
  • MariaDb
  • Oracle
--connection-string (tick)

The connection string of the database to classify. Can also be set via a REDGATE_ANONYMIZE_CONNECTION_STRING environment variable.

Example formats 

--classification-file (tick)

The file path to save the classification to, including file name and file extension.

--options-file (error)

The file path to an options file.

--connection-timeout(error)

The timeout (in seconds) to use when connecting to the database. Default: 90s

--command-timeout(error)

The timeout (in seconds) to use when executing commands against the database. Default: 90s

--output-all-columns (error)

Include all columns in the classification output file, including columns with no classification.

--output-schema-file(error)

Output a schema file to aid with hand editing the classification file.

The schema can be used with some IDEs to provide prompts and documentation on the expected structure when editing.

--output(error)

The format to write any output.

Can be one of:

  • Json (Default)
  • Yaml

--log-level 

(error)

The verbosity level to log at.

Can be one of:

  • Verbose
  • Debug
  • Information (Default)
  • Warning
  • Error
  • Fatal

--log-file

(error)

The location of the log file, or none to disable logging.

 -?, -h, --help 

(error)

Show help and usage information.


Didn't find what you were looking for?