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.

Additional Databases

Select the additional databases, besides the default database, on which you can automatically run this project. Do note that the database needs to have the same meta data as the default database for which you created the project.

 

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 separator 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

 

See the YAML Specification on Wikipedia.org