Datagenator is test data generator for various databases like Firebird, Interbase, MySQL, MSSQL, PostgreSQL, Oracle. Currenty, Datagenerator is at its early development phase. Current data generation is possible using

• Pascal Script
  You can use Pascal Script to have custom generators rather than the built-in ones. For example the following code returns the string TEST for every row.
  
  begin
  Return('TEST');
end.
  
  You can also reach the values of another column by using the GetColumnValue function:
  
  begin
  Return(GetColumnValue('ID'));
end.

• SQL queries
  You can run SQL queries to provide data for a column. There is no such a limitation that you have to run your SQL on the target database. You can have many connections in a project and fetch your data from another database. In the future releases this feature will be improved so that a single query will be able to assign values to multiple columns.

• External Files and Lists
  You can get data to write from text files or from a list that you have just defined in the project.

• Ranged values
  You can generate data between a specified range. The range parameters are very flexible that the datatype doesn't matter at all. Parameters can be date, float, integer, or just a link to another column.
  For example if you have two columns named BIRTH and DEATH in a table then you can generate values for the column BIRTH between 01/01/1921 and 01/01/2006 and also you can generate values for DEATH column between BIRTH and 01/01/2006. So you can ensure that the generated data is valid.

• Static values
  Constant values can be assigned to specific columns. Moreover, values of a column can be copied from other columns in a single row.

• Database sequences
  You can fetch column values from a database sequence.

Open Datagenerator can export the generated data in many ways. ODG can write it directly to the database. Moreover, generated data can be outputted as insert SQL script or CSV file.

Datagenerator projects are saved to XML files.

Datagenerator User Interface (DGUI) is used for easy configuration. DGUI can establish connections to different databases and can show database metadata in a treeview fashion.

Check the screenshots!

You can download the latest version from source forge