Data Architect is the emerging enterprise tool for designing database
EditBy: Discover what database professionals have known for years -- that enterprise databases are designed with enterprise modelling tools. Why has this been a secret for so many? Why do so many labor with Buckets full of error-prone undocumented SQL? Well, it seems no one has been able to pack the features of a quality data modelling tool into a product at a reasonable price -- not until now.

Data Architect is the emerging enterprise tool for designing databases at all levels of an organization, using the same concepts found in tools costing thousands of dollars!
Features

* orkspace/Project oriented environment
* ERD centric data modelling
* Logical Data Model
* Physical Data Model (Oracle, ODBC, SQL92, MySQL, PostgreSQL, DB2, FireBird, MS SQL, SQLBase)
* model panner (birds Eye view)
* quick find and navigation from output window
* model validation
* full documentation capabilities
* integrated Advanced SQL Editor with syntax highlighting
* save/load SQL sessions
* integrated ODBC
* multi-platform (Linux (32 and 64bit), Windows XP, Solaris, HP-UX and OSX)
* open file format (XML)
* DBMS specific features such as data types and SQL syntax
* reverse engineer existing databases
* integrated Team Diagram (general purpose diagramming)
* Dynamically drop/add keys and linked indexes
* Dynamically add foreign keys on tables
* supports table inheritance
* supports: table, view, domain, sequence, procedure, and more
Planned features

* Create modify script (SQL script to modify existing database with data preservation)
* Support for file standard in use by PowerDesigner, Rational etc
* Area zones in order to work with an selected amount of objects
* Full unicode support
* CVS integration, FTP integration you can free download Data Architect 4.1 now.