Figure 0.28 Create Load File
Test data for a table can be generated to a delimited text file. This file can then be used with a Load File to load the data onto the database table. This method is much faster to execute than Insert SQL statements.
This is accessed from the Edit Insert Data Scenario dialog.
To create a template load file, select the target DBMS, enter the name and path of the load file to be created, enter the delimiter that you are using in your test data file and press the Create File push button. Edit the generated template load file to suit your needs. For example, enter the correct file and path names for your data files.
The following shows an example schema.ini file used for a Jet database:
[EnterYourDataFileHere]
ColNameHeader = False
Format = Delimited(,)
CharacterSet = OEM
Col1="ID1" long width 4
Col2="First Name" char width 50
Col3="Last Name" char width 50
Col4="Sex" char width 50
Col5="House Number" char width 5
Col6="Street" char width 50
Col7="City" char width 50
Col8="Post Code" char width 15
Col9="Status" char width 1
Col10="Birth Date" datetimeCol11="System Update TimeStamp" datetime
Figure 0.29 Example schema.ini file for loading a Jet database
