SQL Data Generator for Populating SQL Server Databases

SQL Data Generator for Populating SQL Server Databases


See how 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.
dbForge Data Generator can both work from within SSMS or as a standalone tool.
With the collection of 15+ basic generators, Data Generator analyzes your database schema and automatically selects appropriate generators for each column based on the column name, data type, constraints, and other parameters.
You can also manually tune any generator that was automatically assigned.

Timestamps:
00:00 Introduction
00:17 How to generate test data
00:47 How SQL test data generator works
01:02 See Preview of data to be generated
01:56 Example: generate SLQ test data for the column Order

Find more useful information here: https://www.devart.com/dbforge/sql/data-generator/
Download a 30-days free trial of the Data Generator here: https://www.devart.com/dbforge/sql/data-generator/download.html

#DataGenerator
#dbForge
#SQLServer
#SQL
Closed Caption:

The Data Generation tool by Devart can help you to quickly and easily populate
your database with thousands of rows of coherent, realistic data for testing purposes.
Data Generator can both work as a standalone tool and be launched
internally in the sequel server management studio.
First, just select
the database you want to populate with data.
Then you'll see a dialog with the opened
project's properties which allows you setting up a connection and the initial options.
Imagine you're writing your application
and the first thing you do is creating a bunch of tables which you want to fill
with data that resembles real-world data.
Of course, you could type all that data
by hand but, as you can guess, that's going to be extremely time-consuming and
tedious. So, to avoid doing unnecessary work, you can just delegate the process
to the data generation tool.
dbForge Data Generator analyzes your database schema
and automatically selects appropriate generators for each column based on the
the column name, data type, constraints, and other parameters.
As a result, it cleverly
associates a column with an appropriate generator. You can see the first 50 rows
in the 'Preview of data to be generated' pane.
Data for the LastName column
will be filled from the LastName dictionary.
If a check constraint is
assigned to a column, the tool analyzes it and generates data that will satisfy
the constraint's expression.
By default, the Regular Expression generator creates
US-like addresses, but we can let it generate UK-like addresses instead.
The 'Customer photo' column will be populated with small JPG pictures.
You can also
manually tune any generator that was automatically assigned to a column.
As you can see, the generated data looks very coherent and realistic.
dbForge Data Generator
automatically controls referential integrity for linked tables.
When a child column is a part of a relationship it will, by default, load
data from the parent column in the parent table.
It also correctly handles
multi-column foreign key constraints.
Let's say, you want each Order to contain
from 1 to 5 Order Lines.
To do it, you should just enable the "Repeat each value"
checkbox and set the correspondent number to 5.
As a result,
Order number 108 will contain 3 order lines.
Because our database is
still in a developing state, there is no foreign key assigned
between Customers.CustomerID and Orders.CustomerID.
But it's not an issue
for the data generation tool, so you can manually assign the relationship.
Just replace its generator with "Foreign Key (manually assigned)" and choose the Customer table.
After that, the CustomerID column will be chosen automatically.
We want the tool to generate an order date that is no older than a month, with
the shipping date being not more than 10 days since the order has been placed.
To implement this logic, we would first need to tweak the options of the OrderDate column.
Set its Range as "Offset from now", choose "Use offset details", and then set
the Min to negative 30 and Max to negative 10 Days.
For the ShipDate column,
we should set the Range as "Offset from column", choose OrderDate column, and set Min to
0 and Max to 10 Days.
Ok, now we'll need to tune the default email generator.
You have to do the following steps to generate email addresses based on the
First Name & the Last Name from the corresponding columns. Firstly, you need
to clear the Regular Expression editor. Then you need to type "dot", choose the
LastName column, and, finally, type "@nomail.com".
Now, let's populate the database.
By default, the tool executes the data
population script against the database, but in this case, we want to review
the script in SSMS and execute it later.
To execute the population script, just hit F5.
Just download a 30-days free trial of the Data Generator and find out how easy
and painless the data generation can be.

Video Length: 04:02
Uploaded By: Devart
Published: 10/31/2019
View Count: 7,900

Related Software Products
dbForge Data Generator for SQL Server
dbForge Data Generator for SQL Server

Published By:
Devart

Description:
dbForge Data Generator for SQL Server: Realistic Test Data That Respects Your Foreign Keys dbForge Data Generator for SQL Server is Devart's Windows tool for filling SQL Server and Azure SQL databases with realistic fake data: names, addresses, emails, phone numbers, credit card numbers and 200+ other kinds, generated so foreign keys and check constraints stay valid. It costs $199.95 a year or $399.95 for a perpetual license, with a 30-day free...


Related Videos
dbForge Data Generator for SQL Server Introductory Tutorial
dbForge Data Generator for SQL Server Introductory Tutorial

Video Length: 03:23
Uploaded By: Devart (8/18/2015)
View Count: 5,869

SQL Server Data Generator for Realistic Test Data Creation
SQL Server Data Generator for Realistic Test Data Creation

Video Length: 03:26
Uploaded By: Devart (5/4/2018)
View Count: 4,766

Copyright © 2026, Ivertech. All rights reserved.