Redgate Test Data Manager

Subsetting command-line reference

Run

rgsubset run 
--database-engine [SqlServer | PostgreSQL | MySQL | Oracle]
--source-connection-string "Server=[Your_Server_Address];Initial Catalog=[Your_Database_Name];User Id=[Your_Login_Name];Password=[Your_Password];Trust Server Certificate=true"
--target-connection-string "Server=[Your_Server_Address];Initial Catalog=[Your_Database_Name];User Id=[Your_Login_Name];Password=[Your_Password];Trust Server Certificate=true;"

Flag syntaxRequired?Notes
--database-engine Yes

The type of the database to classify.

Must be one of:

  • MySql 
  • Oracle 
  • PostgreSql 
  • SqlServer 
--source-connection-string Yes

The connection string of the database to subset.

Example formats 

--target-connection-stringYes

The connection string of the database to copy the subset to.

Example formats 

--options-fileNo

The file path to an options file.

--target-database-write-modeNo

Whether to fail or remove the rows if data is present in the target database.

Can be one of:

  • Strict (Default) : Subsetter returns an error if tables in the target database contains rows.
  • Overwrite : Subsetter will delete all rows from tables in the target database that are being subsetted to.
--output-fileNoThe file to save a summary of what has been subsetted to.
--output No

The format of the output written to the console.

Can be one of:

  • Human
  • JSON

--log-level

No

The verbosity level to log at.

Can be one of:

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

 -?, -h, --help 

No

Show help and usage information.



Auth

rgsubset auth --agree-to-eula

Flag syntaxRequired?Notes
--agree-to-eulaYes

Agree to the end-user license agreement.

--start-trialNo

Start a free trial using the account that is currently logged in.

--output No

The format of the output written to the console.

Can be one of:

  • Human
  • JSON

--log-level

No

The verbosity level to log at.

Can be one of:

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

 -?, -h, --help 

No

Show help and usage information.


Didn't find what you were looking for?