Command Line Wizard

Last modified: October 8, 2024

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.