Generate Realistic Test Data for Databases in a Wink

dbForge Data Generator for SQL Server is a powerful GUI tool for a fast generation of meaningful test data for databases. dbForge dummy data generation tool includes 200+ predefined data generators with sensible configuration options, that allow to emulate column-intelligent random data. The tool also allows generating demo data for databases already filled with data and create your own custom test data generators. dbForge Data Generator for SQL Server can save your time and effort spent on demo data generation by populating SQL Server tables with millions of rows of sample data that looks just like real data.

How It Works

With dbForge Data Generator for SQL Server, data generation is easy as pie!

1. Select tables to generate random data for.

2. Select a sample data generator and adjust generation properties.

3. Click the Populate button and get the result!

Great Choice of Sample Data Generators

Over a hundred of various random data generators to populate tables with most frequently used data types

Basic Data Generators


Populate tables with various types of values using basic demo data generators such as Python, Reg Exp, Lorem Ipsum, Text File, Files Folder, Weighted List, and many others.

Business Data Generator


Emulate dummy data of a company's database with departments, industry sectors, IMO, SEDOL, NAICS, and ISIC Rev4.

Health Data Generator


Create exhaustive test data related to health care, in particular, drug names, diagnoses and procedures, drug codes, etc.

IT Data Generator


Generate realistic sample data associated with information technology, including IPv4 and IPv6 addresses, as well as MAC addresses, file extensions, file names, file paths, and others.

Location Data Generator


Generate country-specific demo data for real localized values, such as first names (female and male), last names, addresses, streets, cities, phones (USA, Canada, United Kingdom, Germany, Australia).

Payment Data Generator


Fill payment-related tables with credit card details, currencies, VATID, IBAN, SWIFT-BIC, ABA RTN codes, and more.

Person Data Generator


Create large volumes of personal sample data from names and emails to honorific prefixes, job titles, and social security numbers.

Product Data Generator


Generate dummy data for product tables with such attributes as product names, descriptions, categories, shipping methods, sizes, weights, colors and more.

Developer Bundle Save up to 25

dbForge Developer Bundle for SQL Server

Data Generator is a part of dbForge Developer Bundle for SQL Server - an ultimate kit of fourteen database development and management tools for SSMS. Purchasing the single kit will save you 50% of the cost of each tool as compared to purchasing them individually.

Discount Programs

Get More Solutions for SQL Server

Takes part in DevOps Automation

Use Data Generator along with dbForge DevOps Automation for SQL Server to extend the DevOps approach to SQL Server databases. The solution makes it easy to integrate SQL Server database into the DevOps process without compromising quality, performance, or reliability.

Unveil benefits
Dev Ops

Been in this business for many more years than I wish to admit to and this is one of the best products I have ever used. Once you work your way through the various options and suddenly learn that you can create your own 'pick-list' of values for a field, then the world opens up.

I am using it to develop a small system for my church and as you can imagine they leave the meetings with one understanding and come back with additional requirements later. Since they are volunteers I can't put my foot down and tell them to stop. The advantage your product has given me is the ability to change field content or relationships and quickly build a logical test database quickly. The integrity of the app is maintained as best it can be in this 'hostile' environment through Devart.

user feedback
Michael Godfrey, Founder and CEO, MayRiver Technologies, LLC