ApexSQL Generate 2020.03.0384
ApexSQL Generate 2020.03.0384
Generate random test data for SQL Server.
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 Server data type support
Generate test data across all SQL Server 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 generators
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.
Trigger and Check constraint handling
Disable 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
Display errors, warnings and info messages in the 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 plans
Build inheritance into test data plans by copying existing database settings
Only for V.I.P
Warning! You are not allowed to view this text.