The "Data Generator Project" dialog with the "Project Settings" tab selected
The Project Settings tab allows you to enter a project name and description, as well as to set options for the project. Depending on the data target, different options are available.
There are 5 data targets:
|
Database
|
Generate the data directly to the database
|
|
SQL Script
|
Generate the data to a set of scripts that can be run for against your database(s) at a later time
|
|
CSV File
|
Generate the data to a set of CSV files that can be imported into your database at a later time
|
|
XML DataPacket Files
|
Files as per Delphi TClientDataSet specification
|
|
YAML Files
|
Experimental support for Ruby YAML Files
|
The following options are available for the different data targets:
Database
|
Empty table in reverse order
|
Instead of emptying each (selected) table before generating new data, empty all tables "up front" in reverse order. This is especially useful if your tables are related and your database includes Referential Constraints.
|
SQL Script
|
Insert COMMIT
|
Will insert a COMMIT statement after each batch of rows.
|
|
Overwrite File(s)
|
Automatically overwrite existing files when generating new data.
|
|
To Folder/To File
|
Enter the filename (scripts for multiple tables in a single file) or folder (each item has a different file) where you want your data generated.
|
CSV Files
|
Include header
|
Include a row in the files with the column names
|
|
Use Windows date format
|
Use the current Windows date format instead of a generic SQL standard format
|
|
Column delimiter
|
Data seperator for each field
|
|
Text delimiter
|
Surround character data with this character
|
|
Folder
|
Folder where to generate files to
|
|
Overwrite Files
|
Automatically overwrite existing files in the folder
|
XML DataPacket Files
|
Folder
|
Folder where to generate files to
|
YAML Files
|
Folder
|
Folder where to generate files to
|
|
Overwrite Files
|
Automatically overwrite existing files in the folder
|