The Select Data Generator generates Select SQL statements. The generated statements can be executed directly on your target database which will save the selected data to a results file, or the generated SQL can be saved to file to be executed later on a database and platform of your choice.
The following shows an example results file generated by TurboData for the sample Microsoft Jet database:
-- SQL Statement --
select
[Last Name],
[First Name]
from [Customer]
where [ID1] < 100 order by 1,2
-- Results --
Alvardo Meryl
Barker Emma
Beach Elidia
Beam Sonia
Blakely Lea
Bland Shakia
Bolton Earnestine
Figure 0.1 Example Select SQL results file generated by TurboData
See TurboData Scenarios Overview