Data Generator Project - Project Settings
Previous  Top  Next

After select New Project or Edit Project from the Project List, there's two tabs on the dialog that follows. The first tab holds the Project Settings, the second tab the Data Settings.


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