Select additional scripts

You can configure dbForge Data Generator to execute a 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.

To type or select the scripts to be executed before and/or after data population:

1. Open the Data Population Wizard by clicking in the upper part of the data generation project.

2. Go to the Additional Scripts tab.

Add scripts to be executed before data population

First, click the Scripts to execute before checkbox.

Next, select Use embedded script if you want to manually type the script. Then, in the field below, enter the script you want to be executed before data population.

In case, you want to use a ready-made script stored locally on your machine, click to select the Use external script check box. Then click … to navigate to your script location.

Note

Click to select the Include USE <database_name> check box if you want to specify a database where the operations will be performed.

Add scripts to be executed after data population

First, click the Scripts to execute after checkbox.

Next, select Use embedded script if you want to manually type the script. Then, in the field below, enter the script you want to be executed before data population.

In case, you want to use a ready-made script stored locally on your machine, click to select the Use external script check box. Then click … to navigate to your script location.

Note

Click to select the Include USE <database_name> check box if you want to specify a database where the operations will be performed.