SB Data Generator Features

• Understand your database by visualizing the data model (tables, columns, relationships, keys, sequences, indexes, and triggers)
• Generate a large volume of realistic test data with a couple of clicks.
• Preview what data will be generated before performing the generation.
• Multiple built-in generators available.
• Easy creation of custom data generators.
• Generate test data for: Oracle, MS SQL Server, MySQL, PostgreSQL, Firebird, SQLite, Azure SQL Database, Amazon Redshift and Amazon RDS.

Reverse Engineering

• Ability to manage connections.
• SSL Secure connections (PostgreSQL and MySQL).
• Windows authentication method in MS SQL Server connection.
• Import from local and remote databases(Reverse engineering).
• Import tables, columns, relationships, keys, indexes, and triggers (Only tables and columns in Standard Edition).

Supported Databases

• Oracle database.
• Microsoft SQL Server.
• MySQL.
• MariaDB.
• PostgreSQL.
• SQLite.
• Firebird.
• Microsoft Azure SQL database.
• Amazon Redshift.
• Amazon RDS.

Test Data

• Generate test data on a database sandbox.
• Data forms.
• Data grids.
• Create new data dictionaries.
• Import/export test data from CSV file.
• Manipulate test data on the database sandbox by using the query tool.
• Test data generation (Standard Edition - Generate maximum 10 000 rows per table, Professional Edition - Generate unlimited rows per table).

Visual Data Modeling (Professional Edition only)

• Get ER Diagram after reverse engineering.
• Create multiple diagrams.
• Add table/relationships to a new diagram.
• Show/hide relationships from diagrams.
• Split and merge relationship.
• IDEF1X, Crow's Foot, Codasyl and Relational notations.

Other Features (Professional Edition only)

• Advanced exploration of a data model.
• Ability to find tables, columns, relationships, keys, indexes, and triggers by name.
• Advanced search in the data model browser.
• General, diagrams, tables, and relationships Options management.