Generate Realistic Data in a Wink

dbForge Data Generator for SQL Server is a powerful GUI tool for a fast generation of meaningful test data. The tool includes 200+ predefined generators with sensible configuration options, that allow to emulate column-intelligent real-world test data. dbForge Data Generator for SQL Server can save your time and effort spent on data generation by populating SQL Server tables with millions of rows of test 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 data for.

2. Select a generator and adjust generation properties.

3. Click the Populate button and get the result!

Customer Loyalty 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 Generators

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

Basic Data Generators

Basic

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

Business Data Generator

Business

Emulate 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 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 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 data from names and emails to honorific prefixes, job titles, and social security numbers.

Product Data Generator

Product

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

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