MySQL Data Generator for Random Test Data Producing

In this video we'll talk about dbForge Data Generator for MySQL ⏤ powerful GUI tool designed to create vast amount of dummy data. Data Generator for MySQL includes a collection of 20+ basic random data generators
and 200+ real-world generators that allow you to populate tables with realistic test data.

Data Generation tool analyzes your database schema and automatically selects appropriate generators for each column based on the column name, data type, constraints, and other parameters.

Also, you can manually tune any generator that was automatically assigned to a column.

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.

☑️ Download a 30-day free trial of the dbForge Data Generator for MySQL and find out how easy and painless the data generation can be:
https://www.devart.com/dbforge/mysql/data-generator/download.html

☑️ Find more useful information here:
https://www.devart.com/dbforge/mysql/data-generator/

✅ Subscribe to the Devart Youtube channel:
https://www.youtube.com/user/DevartSoftware

00:00 Introduction
00:25 Beginning of the test data generation
00:55 Automatic/manual selection of an appropriate generators
01:44 Referential integrity control for linked tables
02:20 Manually assign the relationship
02:44 OrderDate option
03:17 Tune the default email generator
03:40 Review the data population script

#MySQL #DataGenerator #MySQLDatabase #MySQLTools #dbForge #Devart #MySQLTutorial

---

Closed Caption:

The Data Generation tool for MySQL by 
Devart can help you quickly and easily
populate your database with thousands of rows of 
coherent, realistic data for testing purposes.
Data generator can either work as a part of the 
enterprise edition or as an independent tool.
In the beginning, you need 
to choose the connection
and the schema you are going to work with.
You can also change numerous original settings.
Imagine you're writing your application and the 
first thing you do is creating a bunch of tables
that you want to fill with data that resembles 
real-world data. Of course, you could type
all that data manually. And as you can guess, 
that's going to be extremely time-consuming and
tedious. So, to avoid unnecessary work, you can 
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 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.
By default, the Regular Expression 
generator creates US-like addresses,
but we can let it generate 
UK-like addresses instead.
Also, you can 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 simply
enable the "Repeat each value" checkbox and 
set the correspondent number to 5. As a result,
the Order number 108 will contain 3 order lines.
Because our database is still in development,
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, first, we 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.
First, 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 and execute it later.
Just download a 30-day free trial of 
the dbForge Data Generator for MySQL
and find out how easy and painless 
the data generation can be.