SchemaBank
SchemaBank is a web-based data modeling and database design tool, delivering to users over the internet using the software as a service (SaaS) model. It supports visual creation of Entity-relationship diagram and conversion of such diagrams into Data Definition Language (e.g. SQL statements).
History
SchemaBank is owned by Ezenso Limited, a Hong Kong-based company. It came into public beta in 2007 August.
Visual creation of Entity Relationship Diagrams
SchemaBank allows users to draw physical entity relationship diagrams (ERD) for the following databases:
- MySQL
- PostgreSQL
SQL statement generation
SQL statements can be generated automatically for all supported database systems.
Reverse engineering
Database schema dump can be imported into SchemaBank and be shown as ERD diagrams.
Version management
Version Control is provided at the project level. Different copies of database design can be committed into the version repository. Users can also create different branches within the version repository.
Reports can be generated to show the difference between any two versions stored inside the version repository. SQL Alter statements can also be generated to migrate the physical database system from one version to another.
Different project sharing modes
Database projects can be shared for either public access or named-user access. Named-user access requires the project owner to add an invitee's email address into the project's access control list.
However, projects under their free plan can be shared only for public access.
See also
- Relational Model
- Computer-aided software engineering
- History of software configuration management