I've been doing some research on various modeling tools which would enable me to easily model databases for future flash projects. Came across two very interesting solutions which should be on your radar.
My requirements are as follows: 1. Feature rich, stable application which allows reverse engineering of existing database. 2. Compatibility with MySQL databases and Linux. 3. Ability to generate SQL statements directly from diagrams. 4. Exporting diagrams as an image and or printing is a must. 5. Uses open standards which allow me to utilize output in other applications. 6. Allow easy navigation of the entire database scheme, which includes finding and navigating to specified table. 7. Minimal cost. Solution 1: DBDesigner4 from fabFORCE.net (http://www.fabforce.net/dbdesigner4/) Fits in-line with all of the above and more. While I do wish that there was an add-on to Eclipse. It's interface is stable offers ease of use, by far a very powerful application which will save me time during the planning phase of extensive projects. DBDesigner4 is also available for the Windows platform and is GNU Licensed. Solution 2: Azzurri Clay from Azzurri Ltd. (http://www.azzurri.jp/en/index.jsp) Another gem which is a native plug-in for Eclipse. Azzurri Clay available in either Core or Pro version, Core being free and Pro costing 35,000 YEN -- about $300 give or take. Sadly to say the Pro version is apparently no longer available for sale outside of Japan according to their english website. While the Core version isn't as feature rich as DBDesigner4, it's worth mentioning if your needs are basic. One thing I found limiting is that there is no export to image which is important if working in a team environment. Clay Core supports additional databases besides MySQL such as PostgreSQL, however, there is no SQL Sever support. As a plug-in for Eclipse it's available on all Java enabled platforms. Stay well, Honeyghan _______________________________________________ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
