ApexSQL Generate

Note: Email Delivery only

SQL test data generator
Test data generation specifically designed for SQL Server developers

Compare
SKU: ApexSQL Generate Categories: , ,

Description

* 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

Full SQL data types support

Generators cover all SQL data types

fancy

Predefined generators

Use 150+ predefined generators for meaningful data e.g. names, addresses, credit card numbers, social security numbers

fancy

Cross-column dependency support

Generate test data based on another column’s values with predefined conditional, string, date and numeric functions

fancy

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.

fancy

User defined generator

Save any generator’s settings so it can be reused later with already prepared setup.

fancy

Table mapping

Use intelligent column recognition pattern to populate table with data from external sources like other database tables and views or CSV files.

fancy

Bypass triggers and Check constraints

Disable Insert and Delete triggers, and Check constraints to avoid referential integrity errors

fancy

Relational integrity support

Include or exclude dependent objects in the generation process

fancy

Exports

Execute the generated data against a database, or choose one of the exporting options

fancy