Hi Adam, I use a little share ware tool called XTG Data Modeller. It's very simple and easy to use. I rarely, if ever, have to modify the scripts it generates. It can do reverse engineering from sql scripts, too. It doesn't connect directly to the database. It's a standalone. Most of the more expensive ones connect directly to the database. But, for the way we work, we don't actually want to do that. We have multiple projects in the same schema, and don't want to look at the whole schema as one database (which is usually how the connected ones work).
They have a free trial, if'n you're interested. http://www.xtgsystems.com/xtgdm.php3 ----- Original Message ----- From: "Cantrell, Adam" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Wednesday, July 30, 2003 9:38 AM Subject: ER diagrams - DDL > Wondering if anyone here uses an ER diagramming tool to help model their new > databases. > > I've been using EnterpriseManager for SQLserver, and PHPMyAdmin for MySQL. > It would be nice if there was a standalone client application out there that > allows you to visually model for various databases and then spits out the > proper DDL code that you can save as .sql files - one for SQL server, one > for MySQL, one for Oracle, etc. I know you'll still have to look at the DDL > after it's generated, but if there's a tool that can help generate an > initial draft for each database, that would be nice. > > I just bought ColdFusionMX Bible (awesome) and it shows screenshots of > ERstudio. Anyone using this? > > Adam. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
