dbForge Data Generator for population Oracle database with test data
See how Data Generation tool for Oracle by Devart can help you quickly and easily populate your database with thousands of rows of coherent, realistic data for testing purposes.
It has 20+ basic and 200+ meaningful generators for various data types.
Data generator can either work as a part of the enterprise edition or as an independent tool.
Find more useful information here:
https://www.devart.com/dbforge/oracle/data-generator/
Download a 30-days free trial of the Data Generator here:
https://www.devart.com/dbforge/oracle/data-generator/download.html
#DataGenerator #Oracle #OracleDatabase #OracleTools #dbForge
Closed Caption:
The Data Generation tool for Oracle 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 Oracle and find out how
easy and painless the data generation can
be.
Video Length: 03:38
Uploaded By: Devart
Published: 11/23/2020
View Count: 1,469