This topic describes how to set up Data Generator to generate test data.
It is recommended to back up the database that you are going to populate before you generate the data. You can adjust the settings and repeat the data generation if you are not satisfied with the results. To generate data, first select a Oracle instance and a database you want to populate.
Specify the connection and select a required schema.
Click Next. The Options page will appear.
Click Execute. The following page displays data generation result. You can specify the tables that you want to populate by selecting the check box that is located next to the table name. Further, you can define how you want the data to be generated: click the table name in the tree view and specify the details in the settings pane. All the changes are displayed in real-time.
There may be errors during data generation. For example, a column may be a foreign key of a table, that is not included into generation. To resolve such issues, navigate to the Related Tables section of the Table generation settings, and include/exclude parent and child tables from data generation.
On the Data Generator toolbar, click Generate Data.
The Output window will open, where you can:
run the script automatically
Select a required option and click Next.
The Summary tab allows you to see the details of an error or warning.
When you are setting up the tables and columns that you want to populate, SQL Data Generator displays warning and error messages to inform you when there may be a problem with the data generation.