Populating Database

To populate a database, do the following:

  1. On the Data Generator toolbar, click Populate data to the target schemas.

    Populate data to the target schemas

  2. On the Data Population Wizard > Output tab, use one of the following options and then click Next:

    • Select the Open data population script in the internal editor option to add custom data to the database
    • Save the SQL script to a file
    • Execute the data population script against the database
  3. On the Data Population Wizard > Options tab, configure the synchronization options and click Next.
  4. On the Data Population Wizard > Additional Scripts tab, enter the script to be executed before or after data population and click Next.

  5. On the Data Population Wizard > Summary tab, view the details of the action plan or warning.

    When you are setting up the tables and columns you want to populate, Data Generator displays warning and error messages to inform you when there may be a problem with the data generation.

  6. To finish the process, click Generate.