Select deployment output

After you configure the data generation project, you can set up the data population process using the Data Population Wizard. First, select an output option to manage the deployment script.

Select an output option

1. At the top of the data generation project, click Populate data to the target database.

Populate data to the target database

2. On the Output page of the Data Population Wizard, select an output option to manage your deployment script.

3. Click Next to configure the data population options.

Select an output option to manage the deployment script

Tip

To save the data population settings to a .bat file to automate recurring scenarios from the command line, click Save Command Line.

Available output options

  • Open the data population script in the internal editor – Opens the deployment script in the internal SQL Editor after you run data population. You can review and edit the script, then execute it to populate the tables with random data.

View the deployment script

  • Save the script to a file – Saves the deployment script to a file on your computer after you run data population.

    • To specify the folder to save the file, click the ellipsis (…), then select the path to the file. The default path to the file is C:\Users\<user_name>\Documents\Data for <database_name> (<server_name>).

    • Optional: To change the editor where you want to open the script before deployment, click the internal editor link. Then select the editor and click OK.

      Select the editor to open the script

    • Optional: To remove the date and time from the file name (added by default), clear Append timestamp to the file name.

  • Execute the data population script against the database – Runs the deployment script automatically without opening it for review.