| CARVIEW |
Select Language
HTTP/2 301
content-length: 0
cache-control: no-cache, no-store, must-revalidate
location: /sql-tools-generate/
set-cookie: ASP.NET_SessionId=jztvo5cifsszddmimcqbw1dy; path=/; secure; HttpOnly; SameSite=Lax
set-cookie: QSTLB=33373962.1.4271802240.3393022464; path=/; httponly;secure ;
x-aspnet-version: 4.0.30319
x-ua-compatible: IE=edge,chrome=1
x-frame-options: SAMEORIGIN
strict-transport-security: max-age=31536000; includeSubDomains; preload
x-content-type-options: nosniff
referrer-policy: strict-origin-when-cross-origin
content-security-policy: upgrade-insecure-requests;
x-permitted-cross-domain-policies: None
permissions-policy: camera=(), microphone=(), payment=()
date: Wed, 30 Jul 2025 23:35:29 GMT
x-cache: Miss from cloudfront
via: 1.1 b9b6427670b2ac1093acaf19c832a61e.cloudfront.net (CloudFront)
x-amz-cf-pop: BOM54-P2
x-amz-cf-id: BoTFGZHKxslwF-IHLdxcHQlAZOgtjnzP7LH1cDrXc6itkJj52MeRfQ==
HTTP/2 200
content-type: text/html; charset=utf-8
cache-control: max-age=14400, s-maxage=86400
server:
x-aspnet-version: 4.0.30319
x-ua-compatible: IE=edge,chrome=1
x-frame-options: SAMEORIGIN
strict-transport-security: max-age=31536000; includeSubDomains; preload
x-content-type-options: nosniff
referrer-policy: strict-origin-when-cross-origin
content-security-policy: upgrade-insecure-requests;
x-permitted-cross-domain-policies: None
permissions-policy: camera=(), microphone=(), payment=()
date: Wed, 30 Jul 2025 23:35:29 GMT
content-encoding: gzip
vary: accept-encoding
x-cache: Miss from cloudfront
via: 1.1 b9b6427670b2ac1093acaf19c832a61e.cloudfront.net (CloudFront)
x-amz-cf-pop: BOM54-P2
x-amz-cf-id: AtPgEUzsKOL6DaKwOpEk9TT_-VK9-NaS0irBlok2F_YCS4EsjUc_Jw==
SQL Server test data generator | ApexSQL
Test data generator
![ApexSQL DevOps toolkit]()
This is the end
Test data generator
ApexSQL Generate is a tool that can populate SQL databases with test data using multiple generators for each column. It supports a full range of SQL data types and can recognize them in a loaded SQL database and provide real-world test data based on contained data types.
Benefits
-
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 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. Learn more
User defined generators
Save any generator’s settings so it can be reused later with an already
prepared setup. Learn more
Table mapping
Use intelligent column recognition pattern to populate table with data from
external sources like other database tables and views or CSV files. Learn more
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
Command Line Interface
Fully automate the test data generation process. Learn more
Visual themes
Customize the visual appearance with interface themes. Learn more
Resources and support
Gallery
Related Topics
Testimonials
Clinical NetwoRx
I have worked for 18 yrs as a developer and for the past 5 yrs I have been an application manager, never have I seen a prompt response in my career. Worked with tons of products most of them not as good, but kudos to you man, you have got a great product and promising support.
Trenton D Souza Application Manager, Clinical NetwoRxConnected System Developer
Thanks for great products!
John Saunders Microsoft MVP, Connected System DeveloperApexSQL Generate is part of the ApexSQL DevOps toolkit
Please wait...