Helpful hint: TurboData may also be used to populate production databases. For example, data for lookup tables may be converted from a projects' Excel spreadsheet, or data may be directly copied from another database on a legacy system.One of TurboData's most useful components for systems development teams is the ability to quickly populate the database with specific test case scenarios.
Use the Insert Data Scenarios to select the tables you wish to generate data for. Update any column to make very realistic looking test data by assigning constant values, or choosing values from various alternate data sources, such as TurboData's generic value database, ASCII text files, Excel spreadsheets, or even another database.
The Expand Selected Table feature allows you to select a parent table, and expand it to add all of it's child tables to the list of selected tables. All the parent/child foreign keys will be automatically resolved correctly.
Use the Set Foreign Keys dialog to control the way a child table is related to parent tables on the database.
Helpful hint: TurboData may also be used to populate production databases. For example, data for lookup tables may be converted from a projects' Excel spreadsheet, or data may be directly copied from another database on a legacy system.
The following shows an example Insert SQL statement for a Microsoft Jet database using random values for various columns:
insert into [Customer]
(
[ID1],
[First Name],
[Last Name],
[Street],
[Sex],
[House Number],
[City],
[Post Code],
[Status],
[Birth Date],
[System Update TimeStamp]
)
values (
1,
'Katharine',
'Dreyer',
'Newchurch Road',
'F',
'23',
'Toronto',
'M5K 1T7',
'X',
'Jan 1 1958 01:02:01AM',
'Nov 5 2001 11:02:07AM')
Figure 0.1 Example Insert SQL statement generated by TurboData
See TurboData Scenarios Overview
