Relational Data Generator can be integrated in build or development pipelines, using the rdgconsole.cmd script.

It provides the "Fill database" features in the same way as in the GUI, but in a comand-line environment.

It is located here: {Your installation directory}\cache\bin\rdgconsole.cmd (by default, the installation directory is C:\Users\{username}\AppData\Local\Programs\Relational Data Generator).

Usage

usage: rdgconsole [OPTIONS] <project_file> fill
       rdgconsole [OPTIONS] <project_file> sql <command>

Where <project_file> is the path to your Relational Data Generator project file.

Commands:
 fill             Fill the database according to the project file definitions.
 sql <command>    Execute an arbitrary SQL command against the database.

Options:
 -h,--help                   Display help message.
 -p,--password-file <arg>    Path to a file containing the database password (UTF-8 text file). This
                             is only required when the password is not stored in the project file.
 -y,--assumeyes              Assume yes: do not request confirmation before executing commands.

Database password

For security reasons, you way not want to store the password to the database in the project file. In the GUI, this is visible in the "Database connections" page, when the "Save password" in left unchecked.

The database password is read in the following way:

  1. First, from the project file.
  2. Second, from the command-line option --password-file is set.
  3. Third, from the standard input.