SQL test data generator
Test data generation specifically designed for SQL Server developers
?Generate SQL test data for specified tables
?Export test data to SQL, XML, CSV, JSON, Excel
?Generate millions of rows quickly
?Customize test data plan with detailed options
?Support a full range of SQL data types
?Choose from multiple generators (Random, List, etc)
?Retain data consistency with foreign key support
?Emulate real-world test data
Features
Full SQL data types support
Generators cover all SQL data types
Predefined generators
Use 150+ predefined generators for meaningful data e.g. names, addresses, credit card numbers, social security numbers
Cross-column dependency support
Generate test data based on another column’s values with predefined conditional, string, date and numeric functions
Customization
Use a wide range of predefined options to customize data, like seed, length, minimum and maximum values, uniqueness of data, and percentage of null values
User defined generator
Save any generator’s settings so it can be reused later with already prepared setup
Table mapping
Use intelligent column recognition pattern to populate table with data from external sources like other database tables and views or CSV files
Bypass triggers and Check constraints
Disable Insert and Delete triggers, and Check constraints to avoid referential integrity errors
Relational integrity support
Include or exclude dependent objects in the generation process
Exports
Execute the generated data against a database, or choose one of the exporting options
Generated data preview
Preview generated data before executing or exporting
GUI warnings
Notify errors, warnings and info messages in tree view and preview panel for incorrect generator settings, circular dependencies, constraint violations, info messages regarding DELETE triggers enforced for the selected column and more
Post generation summary
Track progress, possible errors and the number of rows successfully inserted into the database and the time span of the generation process
Modular test plan
Build inheritance into test data plans by copying existing database settings
Full Command Line Interface support
Automate data generation process with more flexibility
System requirements
Hardware requirements Dual Core 2.0 GHz CPU
3 GB memory
29 MB disk space
SQL Server Microsoft SQL Server 2016, 2014, 2012, 2008 and 2005
Azure SQL Database
Add-in integration SQL Server Management Studio 2016, 2014, or 2012
OS Windows Vista/Server 2008 and above
Required Microsoft .NET Framework 4.5
Note Native support for the x64 arhitecture
Compare
Inputs
CSV or TXT ? ?
Custom list ? ?
Directory ? ?
SQL table or view ? ?
Outputs
Direct execution against database ? ?
CSV ?
Excel ?
JSON ?
SQL static data ?
XML ?
Integration
SQL Server Management Studio (SSMS) ? ?
Generators
Cross-column generator ? ?
Foreign key generator ? ?
Generic (Random, incremental, regular expresion, text shuffler) ? ?
IronPython script ? ?
Table mapping ? ?
Shareable user-defined generator ? ?
Predefined generator 150+ types 60 types
Text generator (Lorem ipsum, sentence generator) ?
Other
Action plan and post-generation summary ? ?
Command line interface ? ?
Disable constraints and triggers prior to generation ? ?
GUI warnings ? ?
Pre-processing and post-processing scripts ? ?
Applying settings to child objects ?
Include/exclude dependent tables ?
Visual dependencies