Automated Test Data Generation
- Generate meaningful test data
- Populate database directly or generate insert scripts
- Data generation based on column characteristics
- Customize data generators (if desired)
- Large collection of pre-installed generators (country/language specific)
- Databases supported: Oracle, MySQL, MS SQL Server, MS Access, MS Azure, SQLite and PostgreSQL
Datanamic Data Generator is a powerful data generator that allows developers to easily populate databases with thousands of rows of meaningful and syntactically correct test data for database testing purposes.
An empty database is not useful for making sure your application will work as designed. You need test data. Writing your own test data generators or scripts is time consuming. Datanamic Data Generator will help you. The tool can be used by DBAs, developers, or testers, who need sample data to test a database-driven application.
Datanamic Data Generator makes database test data generation easy and painless. It reads your database and displays tables and columns with their data generation settings. Only a few simple entries are necessary to generate comprehensive (realistic) test data. The tool can be used to generate test data from scratch or from existing data.
Datanamic Data Generator is a software tool to generate test data for database testing purposes. It inserts generated data directly into the database, or builds insert SQL statements. Below you can find a list of features.
Data generation for multiple database platforms
- Oracle 9i, 10g, 11g and 12. Works without Oracle client software.
- MS SQL Server 2000, 2005, 2008, 2012 and 2014.
- Microsoft Azure.
- MySQL 3,4 and 5.
- PostgreSQL 7,8 and 9.
- MS Access 2000, 2003, 2007, 2010 and 2013.
- SQLite 3.
Intelligently associates a column with a generator based on column characteristics
When the tool analyzes your database schema it automatically selects an appropriate generator for each column based on the column name, language used, data type, constraints etc. Ofcourse you cna change the generator for that column if that is desired.
Over 40 built in/predefined (and customizable) data generators
A large collection of lists, csv files (with addresses etc), date generators, string generators, expression generators etc is included.
Generate test data from scratch or from existing data
You can reuse data from existing sources such as another table or data in an external file.
Generation of data that matches to your database schema
Datanamic Data Generator reads the database schema details from your database. This schema information (metadata) is used for generating syntactically correct data that automatically matches your domain values (data types).
Output generated data to the database or to a SQL insert script
When you start generating the data, you can choose to output to the database or to a SQL file with insert statements.
Single-click test data generation
When you have connected to a database, Datanamic Data Generator automatically chooses the most appropriate data generation settings for each field. Ofcourse you can fine-tune these settings but you can also choose to generate data with this default settings. All you have to do then, is clicking the "Generate data" button.
Referential integrity support
Datanamic Data Generator for racle automatically controls referential integrity for linked tables. When data is inserted, it will be done in the correct order. When a child column is part of a relationship it will by default load random data from the parent column in the parent table. Datanamic Data Generator also correctly handles multi-column foreign key constraints.
Generates data based on user-defined masks
A powerful way to generate meaningful data that matches your needs is to fill a field using the "Random text using mask" generator. By using the "Random text using mask" fill type, you can generate strings that match a defined pattern. You can use the "random text using mask" generator with any data column that has a data type that accepts a string (char, varchar, clob, string, text, etc...) and user-defined types (domains) based on these string types.
- Datanamic Data Generator MultiDB
Oracle, MS SQL Server, MySQL, PostgreSQL, MS Access and SQLite.
- Datanamic Data Generator for Oracle
Oracle 9i, 10g, 11g and 12. Works without Oracle client software.
- Datanamic Data Generator for MySQL
MySQL 3,4 and 5.
- Datanamic Data Generator for MS SQL
MS SQL Server 2000, 2005, 2008, 2012, 2014 and 2016.
- Datanamic Data Generator for Azure
MS Azure (all versions).
- Datanamic Data Generator for PostgreSQL
PostgreSQL 7,8 and 9.
- Datanamic Data Generator for MS Access
MS Access 2000, 2003, 2007, 2010 and 2013.
- Datanamic Data Generator for SQLite
Pricing for Datanamic Data Generator starts at $ 499 for a single user license (EULA).
Upgrade Protection/Support is optional and costs 20% of the initial purchase price per year.
Operating System: Windows 10/8.1/8/7/Vista/XP
Memory: 1 GB minimum (2 GB recommended)
Hard Disk: At least 20 MB of free disk space
Databases: Oracle 9i, 10g, 11g, 12 - MS SQL Server 2000, 2005, 2008, 2012, 2014, 2016 - MySQL 3,4, 5 - PostgreSQL 7,8, 9 - MS Access 2000, 2003, 2007, 2010, 2013, SQLite 3.x
Try Datanamic Data Generator for free
Download a 14-day free trial, and generate data for your test database in a couple of clicks.Download free trial
Save with Bundles
If you buy our software in bundles you save a great deal of money on the price of the individual database tools.