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!

Discount Programs

Send us a link to your MVP profile and get a free license for any SQL Server product!

MS MVP

You can get a significant discount, and even a free license, by spreading a word about Data Generator.

Devart High Five Program for Data Generator

Get 50% OFF for switching to dbForge for SQL Server tools from competing tools!

SQL Complete competitive upgrade

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

Basic

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

Business

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

Health Data Generator

Health

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

IT Data Generator

IT

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

Location

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

Payment

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

Person Data Generator

Person

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

Product Data Generator

Product

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

dbForge Developer Bundle for SQL Server

An ultimate kit of 13 database development and management tools in one package. Grab the full power of dbForge Developer Bundle for SQL Server and benefit from a sensational discount in comparison with buying tools separately.

Developer Bundle Save up to 25

What people say

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.

Michael Godfrey, Founder and CEO, MayRiver Technologies, LLC