Posted on 2005-04-17
Posted by zav@sqlmanager.net
EMS PostgreSQL Data Generator 2.0 utility are now available
online under
"_blank">www.sqlmanager.net
. It can be downloaded from
"http://www.sqlmanager.net/products/postgresql/datagenerator/download"
target="_blank">download page
.
What is EMS PostgreSQL Data Generator?
EMS Data Generator is a powerful utility for generating test data
to several PostgreSQL database tables at once. The wizard
application allows you to define tables and fields for generating
data, set value ranges, generate char fields by mask, load values
for BLOB fields from files, get lists of values from SQL queries
and many other features to generate test data in a simple and
direct way. It also provides console application, which allows
you to generate data in one-touch by using generation
templates.
What are key features of Data Generator 2.0?
- User-friendly wizard interface
- Six languages available: English, French, German, Italian,
Russian and Spanish.
- Generating data to several tables from different databases on
one host.
- All PostgreSQL data types support, including Array, Network
Address and Geometric types.
- Different generation types for each field including list,
random, incremental data generation and more.
- Ability to use SQL query results as list of values for data
generation.
- Automatic control over referential integrity for linked tables
data generation.
- Wide variety of generation parameters for each field
type.
- Ability to set NULL values for certain percent of cases.
- Possibility of saving all the generation parameters, set on
current wizard session.
- Command-line utility to generate data using the template file.