Happy Fish Database Designer 4.3.0

Happy Fish Database Designer 4.3.0 is yet another excellent tool for managers. It is actually an ERD tool combining professional diagramming with a light and pleasant user-interface. The publisher carefully studied the packages of other ERD software vendors before creating Happy Fish and where always astound of the large number of options, switches, rules and other functionality stacked together in one piece of software. Making it almost impossible to learn on the fly without following expensive courses to master the software.

Happy Fish stands out by it's light user interface but providing all the necessary tools you need to create a professional and advanced ERD diagram. Following the standard windows GUI guidelines Happy Fish contains a complete WYSIWYG design environment with many additional tools to make your work as easy as possible.

With Happy Fish you can connect to almost any available database on the market today using ODBC and ADO connections. Using the advanced reverse engineering software you can create a new ERD diagram from an existing database. Importing an Ms Access database into a MySQL or PostgreSQL ERD design? The included reverse engineering feature makes it all possible. Happy Fish includes full schema support. You can also compare your current diagram with an online database.

Happy Fish combines ERD design with live database access to query or maintain an already developed database. You can query or manually alter your database while in the design environment. This is done with the powerful query tool: The "Execute SQL" feature. Execute SQL supports transactions and batch statement parsing and includes history support to keep track of already executed statements. Again with an easy to master user interface.

Major Features:

1. WYSIWYG designer
2. Database schema support
3. Sub diagram support
4. Unlimited number of tables and foreign keys
5. Support for Indexes, constraints, and triggers
6. Support for domains, views, and routines
7. Live database access using ADO/ODBC connections
8. Reverse Engineering of an existing database
9. Comparing models with an existing database
10. Report generation in HTML format
11. Various view/display levels
12. XML based file format
13. Easy printing over multiple pages with preview mode
14. Easy and quick navigation with the model object browser
15. DBMS Translation (Switch target DBMS, using your own data type mapping)
16. Supported Database Systems
    • Oracle   
    • Firebird
    • Microsoft SQL Server
    • PostgreSQL
    • Microsoft Access
    • MySQL
    • IBM DB2 Universal database
    • Max DB
    • Informix Dynamic Server    
    • Interbase

Enhancements: (05-07-2009)

• Added: Image preview window with zoom level control and page selection
  for saving a model as image
• Added: Todo List per model (CTRL-T)
• Added: Support for reserved words. Names are checked during model validation. Lists are located in the resource folder with the .rw file extension which can be edited with a normal text editor
• Added: Column comment export statement for SQL Server
• Added: New style property "Gradient end color" for tables and views
• Added: DDL preview tab in table editor
• Fixed: Style settings for an object on a sub page were applied to the main object
• Fixed: Ms Access script didn't allow double quotes <""> around identifiers. Changed to <[]>

Requirements: no special requirements.