Ken Ismert
KIsmert at TexasSystems.com
Mon Oct 25 13:08:27 CDT 2004
I have used Artiso Visual Case: http://www.visualcase.com/ It has good drawing facilities, and it has a native Access .mdb forward and reverse engineering tool. You can also publish your data model to a web-based viewer. It also will do UML for objects and object pattern design, with .NET and Java support. It sells for about $450 USD for a single user. There is a 30 day free trial. -Ken -----Original Message----- From: MartyConnelly [mailto:martyconnelly at shaw.ca] Sent: Friday, October 22, 2004 7:25 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] document development tools You are probably looking for CASE (Computer Aided System Engineering) Tools. I have used Enterprise Architect http://www.sparxsystems.com.au/ Good for reverse engineering an Access mdb just plug in the mdb or an ODBC connection to SQL and it will layout a data model or ER diagram. Also lays out XSD schemas for tables and queries. Does UML modelling Probably best in it's price range for diagramming $200. There is trial version. Case Studio is good too. It generates SQL table scripts. http://www.casestudio.com/enu/ Then you get into the $1000 price range with ER-Win and WinDev and there are the $10,000 packages Rose, System Architect, and ARTiSAN, and probably even higher mainframe packages.Texas Instrument IEF I saw one about 15 years ago that produced good Cobol Code but none since then. So dont believe any code generation hype with Case Tools. Barbara Ryan wrote: >I received the following email from my client ---- any thoughts / suggestions?.....Thanks, Barb Ryan > > >*************************************************************************** *********************************************** >Do you know of any document development tools, something like VISIO Technical or Quick CAD that >are specifically designed to support a tedium free graphical development of a >table architecture or data model? > >I'm wondering if there is an affordable application out there for >drafting up table schema's and database design diagrams that is easier to use than >wiring together a bunch of text boxes or flow chart symbols in a MSword document. > >Just curious if you know about somthing that the development community uses. > > -- Marty Connelly Victoria, B.C. Canada