Whether desktop or web based, there has recently been a proliferation of SQL design tools on the net. SchemaBank may look like one more in the box. But a detailed look at the features will show you more on offer. SchemaBank is a visual data modelling tool which can help you create ERD diagrams within all modern browsers. It supports MySQL and PostgreSQL.
Some of the features of the product are listed below.
SchemaBank lets you generate SQL statements and other database objects directly from the the ER diagram. Of course many other tools provide it, so no surprises there.
SchemaBank also lets you reverse engineer your existing database schema and import it into SchemaBank for editing.
Versioning and Change Management
One of the unique features of the product, not found in most schema designers, is that of versioning. SchemaBank lets you commit ERD data, Text Objects and database Options to a repository. This lets you easily play with you database schemas without fear of losing vital information, or if you are creating various versions of the database like say for testing and production release. You can also generate diff report showing the difference between two versions of the schemas.
Sharing Database Projects
Database projects created can also be shared with other developers, with the appropriate ‘read’ or ‘write’ access granted by the schema owner. The other developers should have an account with SchemaBank to access the project.
You can enter the SQL statements directly for database objects like views, functions, triggers, etc.
SchemaBank provides a free version with a limit of a single project. The other options cost upward of dollar forty per month.
The product is still in beta, so expect some positive changes before the final release. A live demo can be found here.