ApexSQL Generate

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