Manage data population scripts
Last modified: October 8, 2024
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 in the upper part of the data generation project.
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.
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 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.
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.
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by Data Generator for SQL Server.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.