|
EMS Data Generator for Oracle is an impressive tool for generating test data to Oracle database tables with the possibility to save and edit scripts. The utility can help you to simulate the database production environment and allows you to populate several Oracle database tables with test data simultaneously, define tables and fields for generating data, set value ranges, generate Oracle char fields by mask, define lists of values manually or select them from SQL queries, set generation parameters for each field type and has many other features to generate Oracle test data in a simple and direct way. Data Generator for Oracle also provides a console application, which allows you to generate Oracle test data in one-touch by using generation templates.
Key Features
* Unicode support
* User-friendly wizard interface
* Ability to save and edit generated data in the SQL script without executing queries on the server
* Support of basic Oracle data types including NUMERIC, CHARACTER, DATETIME (DATE, TIMESTAMP), INTERVALS and BINARY (RAW, LONG RAW, BLOB)
* Ability to select different types of data insertion: through INSERT or MERGE
* Generation of data for several tables from different database schemes
* Different generation types for each field including list, random and incremental generation, generation into two and more fields simultaneously
* Ability to use SQL query results as a list of values for data generation
* Ability to preview the generated data
* Automatic control over referential integrity for linked tables
* Ability to disable triggers of the generated tables during the generation process
* Wide variety of generation parameters for each field type
* Ability to set NULL values for certain percent of cases
* Ability to save all generation parameters set on current wizard session into a configuration file
* Command-line utility to generate data using the template file

Keywords: oracle data generation, oracle data generator tool, generate oracle test data, fill oracle with test data, populate oracle database with test data, generate oracle blob data, oracle test data generation tool, create oracle test database data
|

Click to enlarge
|
Related programs in Business - Databases & Tools |
|
DBDocumentor
Produce cross referenced and hyperlinked documentation of SQL databases.
|
|
Advanced XML Converter
Powerful XML converter quickly turning XML files into HTML, XLS, CSV, SQL, DBF
|
|
CDBF for Windows
View, edit and repair the DBF database files, create reports, export data, etc.
|
|
Export Table to Excel for SQL Server
Export Table for Microsoft SQL Server helps to save table's data to Excel file
|
|
BBAutoHarvest
An EASY to use contact manager/follow-up system for customers, or potential cust
|
|
Data Exchange Wizard
Data Exchange Wizard Loads or export data from/into ANY database
|
|
Database Oasis
Create custom databases in minutes using point-and-click with Database Oasis.
|
|
Visual Importer ETL Standard
Extract, transform and load data into ANY Database from ANY Database or file
|
|
Export Schema to SQL for SQL Server
Creates SQL script for database definitions: tables, views, procedures, keys,etc
|
|
FmPro Script Diff
FmPro Script Diff - The external script editor for FileMaker Pro.
|