關於 SB Data Generator

用實際測試資料快速填充資料庫。

SB Data Generator is a simple and powerful tool to generate and populate selected tables or entire databases with realistic test data for your applications. SB Data Generator reverses your database and displays tables and columns, so you can assign to them multiple data generators templates.

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.