Data generators by Jan Kincl Data Generators Jan

Data generators by Jan Kincl Data Generators - Jan Kincl

Outline n n n Introduction Main features My. SQL Data Generators Oracle Data Generators Summary Data Generators - Jan Kincl 2

Introduction Need of prototype of application n Filling database with meaningful data n Manually is slow ------------------n => DATA GENERATORS! Data Generators - Jan Kincl 3

Main features n n Defining tables and fields for generating data (including user values) Connection to database (oracle/My. SQL) Generating data to several tables at once Generating SQL code Data Generators - Jan Kincl 4

My. SQL Data Generators n n www. generatedata. com Turbo. Data (also oracle) Data Generators - Jan Kincl 5

www. generatedata. com n n n 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

Turbo. Data n n n Free trial Filling more tables (automatic foreign key recognition) Possibility of connection to database and downloading schema Can generate data for My. SQL, Oracle, … Full version: $200 : -( Data Generators - Jan Kincl 8

Data Generators - Jan Kincl 9

Oracle Data Generators n n EMS Data Generator for Oracle DTM Data Generators - Jan Kincl 10

EMS Data Generator for Oracle n n n 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 My. SQL available Price: $95. 00 : -) Data Generators - Jan Kincl 11

Data Generators - Jan Kincl 12

DTM Data Generator n n Connect with database DBMS: MS SQL Server, Oracle, DB 2, My. SQL, Postgre. SQL, Fire. Bird Many libraries for realistic data generation Price: $159 : -( Data Generators - Jan Kincl 13

Data Generators - Jan Kincl 14

Summary n Questions? : -( Data Generators - Jan Kincl 15

References n n Generatedata: www. generatedata. com Turbo. Data : 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