Generate 100 Customers with Default Data

Now you have read the sample database schema into TurboData we can start to load it with data.

• From the Scenario menu, select the New Scenario option.
• Enter the Name 'Create Customers', and press OK.

  

• The Edit Insert Scenario dialog will be opened automatically. Click on the Customer table, keep the mouse button down, and drag the arrow icon over to the right hand tree. Release the mouse button.

  

• Click on the Customer table that you now see in the right tree to give it focus. The background colour of the tree in focus is white.
• Enter '1' in the Start Range, and '100' in the End Range
• Press the Generate push button to open the Generate SQL dialog

  

• Click on the Update Database option
• Press the Generate push button to Generate the data and automatically load it on to the target database.
• Press the View Data on Target DB push button to open the Edit Data dialog. Select Customer from the Table drop down list, and you will see 100 Customers have been created with default test data.