How to generate data from the command line
You can automate data generation using the command line.
- Click Start, type ‘cmd’ in the Search programs and files text box, and press ENTER. The Command Prompt opens.
- Specify the operation you want to perform and the required parameters and arguments (actions you want to run) in the Command Prompt, for example as follows:
dbforgesql.com /generatedata [/switch1[:value | [parameter1:value parameter2:value ..]] /switch2 ..]\ - Press ENTER to run the process.
Select corresponding command line switches to perform the required operations:
| Argument | Action and Usage |
|---|---|
| /connection | This switch is used to specify a connection string. The command line looks like: /connection:<connection_string> |
| /errormode | This switch is used to specify the application behavior when an error is encountered. To ignore all errors during the data population, specify: ignore. To cancel the data population if any error occurs, specify: abort. The command line looks like: /errormode:<ignore|abort> |
| /password | This switch is used to specify a password. It overrides the password specified in the connection string. The command line looks like: /password:<pw> |
| /projectfile | This switch is used to specify data generation template to use. Some project options can be overridden by switches. The command line looks like: /projectfile: <path> |
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?