Select additional scripts

You can configure the Data Generator tool to execute the specified script before and/or after data population. You may need this option in a number of cases, for example, to drop the old data or disable triggers before data generation and then enable them again.

Add scripts to be executed before and/or after data population

1. Open the Data Population Wizard by clicking Green arrow Populate data to the target database in the upper part of the data generation project.

2. Go to the Additional Scripts page to add scripts to execute before or after data population.

Additional Scripts

3. Select the Scripts to execute before or Scripts to execute after checkboxes and then select one of the following options in the corresponding section:

  • Use embedded script to enter a script in the field.

  • Use external script to use a script stored locally on your machine. Click … More options to specify the path to the file with the script. If you want to specify the database where the operations will be performed, select the Include USE < database_name > option.

After you added scripts, you can switch to the Summary page and review data population actions and warnings.