Data generators

1
Data generators

• by Jan Kincl

2
Outline

• Introduction
• Main features
• MySQL Data Generators
• Oracle Data Generators
• Summary

3
Introduction

• Need of prototype of application
• Filling database with meaningful data
• Manually is slow
• ------------------------------------
• gt DATA GENERATORS!

4
Main features

• Defining tables and fields for generating data
  (including user values)
• Connection to database (oracle/MySQL)
• Generating data to several tables at once
• Generating SQL code

5
MySQL Data Generators

• www.generatedata.com
• TurboData (also oracle)

6
www.generatedata.com

• Online, FREE, open source
• generates data in XML, Excel, HTML, CSV or SQL
• generates names, phone numbers, email addresses,
  cities, states, provinces, counties, dates,
  street addresses, number ranges, alphanumeric
  strings, lorem ipsum text and more.

7
(No Transcript)
8
TurboData

• Free trial
• Filling more tables (automatic foreign key
  recognition)
• Possibility of connection to database and
  downloading schema
• Can generate data for MySQL, Oracle,
• Full version 200 -(

9
(No Transcript)
10
Oracle Data Generators

• EMS Data Generator for Oracle
• DTM Data Generator

11
EMS Data Generator for Oracle

• Generating data to several tables
• Support for generic Oracle data types binary
  types (RAW, LONG RAW, BLOB)
• Ability to set NULL values for certain percent of
  cases
• Version for MySQL available
• Price 95.00 -)

12
(No Transcript)
13
DTM Data Generator

• Connect with database
• DBMS MS SQL Server, Oracle, DB2, MySQL,
  PostgreSQL, FireBird
• Many libraries for realistic data generation
• Price 159 -(

14
(No Transcript)
15
Summary

• Questions? -(

16
References

• Generatedata www.generatedata.com
• TurboData http//www.turbodata.ca/
• EMS Data Generator http//www.sqlmanager.net/en/p
  roducts/oracle/datagenerator
• DTM Data Generator http//www.sqledit.com/dg/inde
  x.html