Most modern tools can generate a script or "forward engineer" straight to the database. The first option (script) lets you see *exactly* what is being done. I recently used Sybase Powerdesigner 9 (10 is out now) to generate an oracle schema totaling over 30k lines of script (including auto-generated pl/sql packages and data for lookup tables). I also always start with pencil and paper, but you can't manage a database that size by hand without making mistakes - especially when you start making changes. Dropping your database every night and recreating from a script stored in CVS ensures that even if a developer is quietly altering tables in his own little corner... he won't do it more than once.
Yes, you can manage your database in ISQL or SQL/Plus if you want to. You can also write your CF code in notepad or vi. just my 0.02 $ /t >-----Original Message----- >From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] >Sent: Monday, January 17, 2005 6:07 PM >To: CF-Talk >Subject: Re: DB Survey > >Here, here, Tony... > >Long live low-tech!! Soapstone and slate forever! > >I've been using a combination of brains, paper, and colored >Sharpies forever. > >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. > >Laterz, >J ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190785 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