Transcript Data generators

Data generators
by Jan Kincl
Outline





Introduction
Main features
MySQL Data Generators
Oracle Data Generators
Summary
Data Generators - Jan Kincl
2
Introduction
Need of prototype of application
 Filling database with meaningful data
 Manually is slow
-----------------------------------
=> DATA GENERATORS!
Data Generators - Jan Kincl
3
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
Data Generators - Jan Kincl
4
MySQL Data Generators


www.generatedata.com
TurboData (also oracle)
Data Generators - Jan Kincl
5
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.
Data Generators - Jan Kincl
6
Data Generators - Jan Kincl
7
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 :-(
Data Generators - Jan Kincl
8
Data Generators - Jan Kincl
9
Oracle Data Generators


EMS Data Generator for Oracle
DTM Data Generator
Data Generators - Jan Kincl
10
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 :-)
Data Generators - Jan Kincl
11
Data Generators - Jan Kincl
12
DTM Data Generator




Connect with database
DBMS: MS SQL Server, Oracle, DB2,
MySQL, PostgreSQL, FireBird
Many libraries for realistic data generation
Price: $159 :-(
Data Generators - Jan Kincl
13
Data Generators - Jan Kincl
14
Summary

Questions? :-(
Data Generators - Jan Kincl
15
References




Generatedata: www.generatedata.com
TurboData : http://www.turbodata.ca/
EMS Data Generator:
http://www.sqlmanager.net/en/products/o
racle/datagenerator
DTM Data Generator:
http://www.sqledit.com/dg/index.html
Data Generators - Jan Kincl
16