dbForge Data Generator for Oracle Features

• Full support for essential column data types
  • The tool supports a massive range of column data types, including:
    • NUMBER
    • VARCHAR2, NVARCHAR2, CHAR, NCHAR
    • DATE
    • TIMESTAMP
    • INTERVAL YEAR TO MONTH
    • INTERVAL DAY TO SECOND
    • BLOB, CLOB, NCLOB
    • XMLTYPE
• Flexible data customization
  • Data generation options enable you to setup each data generator up to your needs. You can customize:
    • Number of NULL values
    • Number of empty values
    • Data uniqueness
    • Country-specific data
    • Value ranges
    • Value distribution mode
    • Row distribution mode
    • Data generation by time and by specified number of rows
• Data integrity support
  • The tool supports foreign keys (auto- or manually assigned to the column) to maintain data integrity when populating multiple tables. Disabling triggers and check constraints allows:
    • Getting accurate generated data.
    • Improving performance and data synchronization process.
    • Saves time and efforts when working with databases and generating data.
    • Specify application behavior when an error occurs.
• Domain integrity support
  • Data Generator supports SQL CHECK constraint feature that:
    • Helps you easily generate consistent data across a single column or multiple columns of a table.
    • Assures data integrity.
    • Improves data accuracy results.
    • Increases data quality.
  • With the Data Generator tool, disabling check constraints helps you avoid interference with database logic.
• Multiple ways to populate data
  • With the Data Population options, the generated data population script can be managed in the following ways:
    • Open the script in the internal editor to add data to the database.
    • Save the SQL script to a file for the future use.
    • Run the script against a database.
  • In addition, data population can be customized up to your needs that may include:
    • Rollback changes during synchronization.
    • Disable foreign keys and check constraints in the databases.
    • Use SQL*plus commands.
• Basic generators
  • With the collection of 15+ basic generators, you can populate tables with various types of values. The tool includes the following generators:
    • String
    • Constant
    • Files Folder
    • Foreign Key
    • Lorem Ipsum
    • Regular Expression
    • Shuffled Text
    • SQL Query
    • Table or View
    • Weighted Lists
• Meaningful generators
  • dbForge Data Generator for Oracle includes 200+ meaningful generators that allow to populate tables with realistic test data. In particular, tool can fill your tables with:
    • IDs
    • Post codes
    • Phone numbers
    • Countries
    • Credit card numbers
    • First & Last Names
    • Product Categories
• User-defined generators
  • With Data Generator templates, you can create, save, and use your own generators that would better meet your needs, instead of customizing existing generators over and over again.
• Command-line interface
  • With the command-line functionality, you can save time by scheduling routine data generation tasks.
    • Automating data generation.
    • Maintaining PowerShell compatibility for automatic data generation.
    • Saving a .bat file with data generation settings for later use.
    • Formatting the code through the command line.