EMS Data Generator for PostgreSQL

What is EMS Data Generator for PostgreSQL?

EMS Data Generator for PostgreSQL is an impressive tool for generating test data in PostgreSQL database tables with the ability to save and edit scripts.

The utility can help you simulate the database production environment and lets you populate multiple PostgreSQL database tables with test data simultaneously, define tables and fields to generate data, set value ranges, generate PostgreSQL character fields by mask, set value lists manually, or select them in SQL queries,  set generation parameters for each field type and have many other features to generate PostgreSQL test data simply and directly. Data Generator for PostgreSQL also provides a console application, which allows you to generate PostgreSQL test data with one touch, using generation models.

Core features

• Unicode support.
• Wizard-friendly interface.
• Ability to save and edit data generated in sql script without running queries on the server.
• Generating data on multiple tables of different databases on a host.
• Support for all postgresql data types, including arrays, network addresses, GEOMETRY types, BIT fields, user-defined data types based on simple types.
• Different generation types for each field, including list and random generation, generation in two and more fields simultaneously.
• Ability to use SQL query results as a list of values for data generation.
• Ability to view the generated data.
• Automatic referential integrity control for linked tables.
• Wide variety of generation parameters for each field type.
• Ability to set NULL values for a given percentage of cases.
• Ability to save all generation parameters defined in the current wizard session in a configuration file.
• Command-line utility for generating data using the template file.

System requirements

Microsoft Windows XP, Microsoft Windows Server 2003, Microsoft Windows Server 2008, Microsoft Windows Server 2008 R2, Microsoft Windows Server 2012, Microsoft Windows Server 2012 R2, Microsoft Windows Server 2016, Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows 8 / 8.1, Microsoft Windows 10

20 MB of available HD space for program installation

Possibility to connect to any local or remote PostgreSQL server