Datanamic Data Generator
Datanamic Data Generator creates meaningful, syntactically correct test data for database testing.
What Datanamic Data Generator is
Datanamic Data Generator creates meaningful, syntactically correct test data for database testing. Datanamic identifies database administrators, developers, and testers working with database-driven applications as its intended users. The Windows software supports Oracle, SQL Server, PostgreSQL, Access, MySQL, SQL Azure, Firebird, InterBase, and SQLite. It can generate data from scratch or reuse it from another table or an external file.
The tool analyzes column names, language, data types, and constraints to choose generators, and users can change those choices. Its library has over 40 predefined, customizable generators, including lists, CSV data, dates, strings, and expressions. Results can be inserted into a database or written to a file as SQL insert statements. For linked tables, it supports referential integrity and multi-column foreign key constraints. Version 9.0 added SSL support; the listed version 9.1.0 supports SQL Server 2022, Oracle 23c, and PostgreSQL 16. Pricing starts at €25/mo, with a 14-day trial and no free plan. Datanamic says the product is no longer a core product.
Good
- Supports nine listed database systems
- Includes over 40 customizable generators
- Can reuse data from tables or external files
- Writes SQL inserts or inserts data directly
- Supports referential integrity and multi-column constraints
Watch out
- No free plan
- Windows only
- Technical support requires an active contract or subscription
- Datanamic says it is no longer a core product
Who it suits
It suits DBAs, developers, and testers who need generated data for database testing, particularly when their work involves linked tables or multiple supported database systems.
Verdict
Data Generator offers broad database support and options for controlling generated data and relational constraints. Buyers should note its Windows-only platform, paid starting price, and discontinued core-product status.
The facts
Each one read from Datanamic Data Generator's own pages, with the date it was checked.
Where it runs
- Automatic field mapping
- The software selects generators using column names, language, data types, and constraints, and users can change those selections.checked 4 Oct 2026
- Platform requirements
- The specifications list Windows 11, 10, 8.1, 8, 7, Vista, and XP, with 1 GB minimum memory, 2 GB recommended, and 20 MB free disk space.checked 9 Oct 2026
What it does
- Automatic field matching
- The tool analyzes column names, language, data types, and constraints to select a generator, which users can change.checked 9 Oct 2026
- Built-in generators
- The product includes over 40 predefined and customizable generators, including lists, CSV files, date, string, and expression generators.checked 9 Oct 2026
- Database support
- Supported databases listed are Oracle, MS SQL Server, PostgreSQL, MS Access, MySQL, Microsoft SQL Azure, Firebird, InterBase, and SQLite.checked 9 Oct 2026
- Data sources
- Generated data can start from scratch or reuse data from another table or an external file.checked 9 Oct 2026
- Intended users
- The maker says DBAs, developers, and testers can use it to create sample data for database-driven applications.checked 9 Oct 2026
- Latest listed version
- The version history lists version 9.1.0 with support for MS SQL Server 2022, Oracle 23c, and PostgreSQL 16.checked 9 Oct 2026
- Operating system
- The specifications list Windows 11, 10, 8.1, 8, 7, Vista, and XP.checked 4 Oct 2026
- Output
- Generated data can be inserted directly into a database or written to a SQL file as insert statements.checked 9 Oct 2026
- Product status
- Datanamic says Data Generator is no longer a core product.checked 9 Oct 2026
- Purpose
- The software generates meaningful, syntactically correct test data for database testing and can populate databases with thousands of rows.checked 9 Oct 2026
- Relational integrity
- The product handles linked tables in insertion order and supports multi-column foreign key constraints.checked 9 Oct 2026
- Relationships
- The product supports referential integrity for linked tables and multi-column foreign key constraints.checked 4 Oct 2026
- Security feature
- Version 9.0 added SSL support.checked 4 Oct 2026
- Support
- Datanamic directs customers to its Support Portal for support answers.checked 9 Oct 2026
- Transport security
- The version history says SSL support was added in version 9.0.0.checked 9 Oct 2026
The company
- Headquarters
- The company page lists Datanamic Solutions at Rapenburg 8, 2311 EV Leiden, The Netherlands.checked 9 Oct 2026
- Maker and founding
- Datanamic says it was founded by Rick van Dijk in 1999.checked 9 Oct 2026
Alternatives to Datanamic Data Generator
- 1
FakerForge
Free planWebAPILinuxmacOS7.8From $10 a month - 2
Windocks
Free planWebAPILinuxSelf-hosted6.9From $499 a month - 3
Databucket
Free planOpen sourceAPISelf-hosted6.8Free plan - 4
Tonic Fabricate
Free planWebAPISelf-hosted6.8$29 usage-based - 5
Data Maestro
Free planLinuxmacOSSelf-hosted6.7From $149 a year - 6
Mockaroo
Free planWebAPISelf-hosted6.7From $60 a year