I use dbdesigner by fabforce Fabforce.net
Open source project ;) Pat -----Original Message----- From: Dave Merrill [mailto:[EMAIL PROTECTED] Sent: May 20, 2005 16:40 To: CF-Talk Subject: RE: DB Design, Engineering & Re-Engineering Software Haven't gotten around to actually trying it, but DDS-Lite looks good: http://www.dds-lite.com/ Interesting bullets from their feature list: --------------- - Enhanced Entity Relationship Diagram modeling allows you to design a fully relational database, complete with Cascading Referential Integrity Constraints, Indexes, Checks, Defaults and Unique constraints. - Data Structure Diagram that is created automatically from the Enhanced Entity Relationship Diagram shows the complete table structure. - Data Definition Language (DDL) Scripts for creating, dropping and loading the database can be quickly and easily generated for all of the supported database servers. - Cross DBMS Target Compatibility allows you to design once and create for all. No need to concern yourself with vendor specific variations to SQL syntax. All is handled by the application. - Supports All Major Databases including Oracle, DB2, SQL Server, Informix, Sybase (ASA and ASE), MySQL, PostgreSQL, Interbase, Access, SQLBase, Ingres, ANSI and Pervasive SQL. - Template Language to define the Data Definition Language scripts allows you to create the scripts exactly as you want them. - Java Source Code can be created directly from the Enhanced Entity Relationship Diagram to contain the Data Definition Language for any of the supported database targets. Source code can be compiled and executed from within the DDS-Lite environment. --------------- The $100 version doesn't do views, procedures, triggers, reverse engineering from existing dbs, or splitting big projects into multiple models. The $400 version does. Dave Merrill > Any recommendations on DB software much less expensive then Erwin? > > Andy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207315 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
