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.