I discovered and worked with Object Relationship Modelling (ORM) a few months ago, downloaded their (can't remember who "they" are at the moment) tools, and tried to use them to model my DB and go direct-to-script with it.
I've used the Access, SQL Server, FileMaker Pro, Sybase, and MM SQL generators (from MM in CF Studio and the new one in DW 7.1) and I've always found they made the code bulkier, klunkier, and so on, than it really needed to be. For tasks like designing DB structure, where you simply sketch out the tables and relationships in a "drawing" that's converted to code, I'll admit I've never used one. I've always either written the defs out or used an IDE to create the tables and assign indexes. Nothing I've used to date is very good at doing things like triggers, sprocs with any kind significant logic, or anything like that. The ORM tool I downloaded promised to do all those lovely things, but it so lacked any form of intuitive-ness that I scrapped it and used SQL Server's EM IDE and query analyzer. I will admit this, though: SQL Server's sproc wizard can be handy for creating CRUD sprocs for each individual table. They need a little editing, but they're close, and they form a foundation for higher-functioning sprocs later on. Laterz, J On Mon, 17 Jan 2005 17:18:17 -0000, Nick de Voil <[EMAIL PROTECTED]> wrote: > > And I have a hard time trusting anything that goes from diagram to DB > > FOR you, mostly because I've never seen anything auto-generated by > > anything that auto-generates that was really as well-done as it could > > have been. > > What type of shortcomings do you have in mind? > > Nick > > > -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190884 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
