dbForge Data Generator for SQL Server Introductory Tutorial

dbForge Data Generator for SQL Server Introductory Tutorial


Learn how to quickly populate an SQL Server database with meaningful test data.
Learn more: http://www.devart.com/dbforge/sql/data-generator/
Closed Caption:

Welcome to dbForge Data Generator for SQL
Server Tutorials.
In this tutorial, we will learn how to quickly generate large volumes of SQL Server test table data.
With the Start Page of the application, you can
open recently saved projects or create a new one.
Select a connection and a database.
On the Options page you can select a value
distribution mode and set other default options.
Select to generate 100 rows.
Now we can proceed with data generation.
To quickly find the EmailAddress table, Type
'email' into the Find box.
Select the table from the list.
Note, there is a warning next to the table name.
The reason of the warning is that the ID column is
a foreign key of a table, that is not included into
generation.
To view and select child and parent tables, navigate to the table generation settings.
As you see, dbForge Data Generator supports
foreign keys for generation of consistent data
across multiple tables.
You can also set the number of rows to be
generated for every table.
Select the required table.
Clear the Find box, and then double click the
required table.
Select its parent table.
For each column, you can select one of the built-in generators and customize it.
The list of generators can be completed with your
own user-defined generators.
Also, you can create your own generator using
one of basic generators.
Select one of meaningful generators from the list.
Let's consider the default expression for the
Email generator.
The expression references text files with the
most common first and last names.
All generators are stored as XML files at the
following folder.
Let's open one of the existing file generators.
It consists of Name, Short Name, Description,
Expression and other tags.
You can complete the list with your own
generators and modify existing ones.
Here you can preview the result data.
You can specify general settings for each data type.
Now, let's deal with generator for the int column.
For the datetime column, you can also set minimal
and maximal values for date, time and fraction.
Now we are ready to populate our database with the generated data.
You can see the target database settings.
Select to save the generated script and open it in
the internal editor for the subsequent use.
Next, on the Options page, select the 'Disable
check constraints' and 'Disable DML triggers'
options.
On the Summary tab, we can see the warning, that is caused by the preset options.
Switch to the Action Plan tab, and view the detailed list of data population actions.
Now we are ready to start generating the data
population script.
Here is our executable script.
Let's execute it.
The script has been executed successfully.
dbForge Data Generator for SQL Server saves your time and effort spent on test data generation.
Download a free 30-day trial of the tool, and try it
on your own.
Thank you for watching.

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

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
SQL Data Generator for Populating SQL Server Databases
SQL Data Generator for Populating SQL Server Databases

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

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.