Command Line Wizard
Data Generator incorporates a built-in Command Line Wizard that allows converting the project’s data generation options into command-line syntax and save it as a *.bat file.
It is a very convenient feature when it comes to scheduling or automating database population tasks. You can then use a *.bat file with a script and Windows Task Scheduler or any other task scheduler tool available to schedule the data generation.
You can select command-line file settings to manage *.bat file text in the Command line execution file settings window. You can open the window by clicking the Save Command Line button in:
- Data Generator Project Properties Window
- Data Population Wizard
Options of the Command Line Wizard
The command line wizard has the following options:
| Option | Description |
|---|---|
| Project File | You can use this option to specify a data generation template to use |
| Connection | Use this option to specify the connection settings here |
| Password | The option helps to specify or override the server password |
| Error Mode | You can use this option to define the application behavior in case an error is detected |
| Treat Warning as Error | Specify whether to treat warnings as errors or not. When YES is selected, the further behavior is determined by the Error Mode option |
After setting the required options for the potential script, you can click Validate to check the accuracy of the code.
If the syntax is valid, you receive the following message:
Otherwise, the correspondent warning will be displayed:
After validating the code, you can save the script as a *.bat file by clicking the Save button and specifying a path to its location.