Manage data population scripts

After you have configured the data generation project, you can use the Data Population Wizard to manage the data population script. To open the Data Population Wizard, click Green arrow in the upper part of the data generation project.

Deployment wizard

There are the following possible steps in the Wizard:

  • Open the data population script in the internal editor

If this option is selected, the script for data population will be opened in the internal editor of the Data Generator tool. You will be able to make changes to it if necessary and then execute it by clicking the Execute button on the toolbar menu.

Script opened in the internal editor

Note:

You can select SQL editor to open your script with. Click the internal editor link to open the Options window. In the Data Generation section click Population and select the SQL editor you want.

Save command line settings

  • Save the script to a file

If you can save the script locally on your PC, select this option and specify a path to a folder you want to save the script to. Here you can also adjust two additional options:

  • Open script in the internal editor to open the script in the internal editor after saving.

  • Append timestamp to the file name is selected by default and automatically adds a timestamp to the specified file.

Script opened in the internal editor

If you want to remove the timestamp, clear the checkbox.

  • Execute the data population script against the database

Select this option, if you want to execute the script without reviewing it.

Note

You can save the data generator project settings as a .bat file for recurring data population scenarios. This will allow you to avoid configuring project again and again. Click Save Command Line to adjust command line file settings.

Save command line settings