Automate data generation from the command line

The /generatedata command allows you to run data generation from the command line.

Note

The command-line interface is available in the Professional and Enterprise editions of dbForge Studio for SQL Server.

Syntax

dbforgesql.com /generatedata [/option_name1[:value | [parameter1:value parameter2:value ..]] /option_name2 ..]

Get command-line help

To view the list of arguments available for the /generatedata command, run the following command:

dbforgesql.com /generatedata /?

Command details

  • Enter all the required arguments directly in the Command Prompt.
dbforgesql.com /generatedata /connection:"Data Source=<server_name>;Encrypt=False;Integrated Security=False;User ID=<user_name>" /errormode:abort
  • To execute the command, press Enter.

Examples

Generate data using a project file

  • This command generates data based on the settings saved in the project file (.dgen). It also uses the connection string specified in the project, but the password is provided directly in the Command Prompt using the /password switch.
dbforgesql.com /generatedata /projectfile:"D:\doc.dgen" /password:admin
  • This command generates data based on the settings saved in the project file (.dgen). The connection string is provided directly in the Command Prompt using the /connection switch.
dbforgesql.com /generatedata /projectfile:"D:\doc.dgen" /connection:"Data Source=server_name;Initial Catalog=custom_database;User ID=admin;Password=admin"
  • This command generates data based on the settings saved in the project file (.dgen). It also uses the connection string specified in the project file. The application behavior is defined with the /errormode switch.
dbforgesql.com /generatedata /projectfile:"D:\doc.dgen" /password:admin /errormode:ignore

For a complete list of command-line switches, see Command-line switches.