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.