Products
- Database Tools
  
  Must-have tools for database development, data analysis, data management, and server administration
  
  SQL Server Tools
  
  MySQL Tools
  
  Oracle Tools
  
  PostgreSQL Tools
  
  Data Connectivity
  
  Wide choice of world-class data connectivity solutions for various data connection technologies and frameworks
  
  ADO.NET Data Providers
  
  ODBC Drivers
  
  SSIS Components
  
  Excel Add-ins
  
  Delphi Data Components
  
  dbExpress Drivers
  
  Productivity Tools
  
  Tools that help developers to write code, conduct code reviews, compare sources, track the working time, and much more
  
  Coding Assistance Tools
  
  ORM Solutions
  
  Time Tracking App
  
  Data Services
  
  All-in-one cloud data platform for no coding data integration, data access, cloud to cloud backup, and management
  
  Data Integration Services
  
  Cloud to Cloud Backup
  
  Online SQL Tools
  
  OData Server
  All Products Free Products
Store
Support
- Tech support
  
  Questions or problems? Our dedicated support teams can answer product related questions.
  
  Request Support
  
  Documentation Center
  
  Forums
  
  Using Website
  
  Sales support
  
  Answers to all common questions that you might have and a bit more.
  
  Ordering FAQ
Blog
Company
- About us
  
  Learn more about the company, people, vision, and history
  
  About us
  
  Customers
  
  Partners
  
  Resellers
  
  Contacts
  
  Resources
  
  Get updated with the latest worldwide events.
  
  Events
  
  Community
  
  Join our community of technology experts. Learn something new or share your experience with a wide audience.
  
  CodingSight

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

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

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

Health

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

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

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

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

Person

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

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

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.

learn more try now

Discount Programs

Devart offers multiple ways to save money on new license purchases and get Devart products absolutely for FREE

More Discount Programs

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

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

Devart High Five Program for SQL Complete

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

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

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.