RE: DB Survey
We use XTG Data Modeller. A visual CASE tool for data structure modelling and documenting, reverse engineering and exploring databases. http://www.xtgsystems.com/xtgdm.php3 -Kevin -Original Message- From: Tiki Guy [mailto:[EMAIL PROTECTED] Sent: Monday, January 17, 2005 6:18 AM To: CF-Talk Subject: DB Survey Hi All, Just curious as to what applications people use when designing their DB's - Visio? Pen and Paper? Bueller? My current shop likes to wing it and frankly that's not so good. I'd like to recommend something a little more standardized, and if I can ascertain what might be considered an industry standard, my suggestion might carry more weight. I've always been a pen and paper guy, doing data dictionaries first and determing relationships before committing to the DB. I'd like soemthing though, that is a bit more portable (and readable) than my chicken scratch. ~Tikiguy ~| 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:191104 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
DB Survey
Hi All, Just curious as to what applications people use when designing their DB's - Visio? Pen and Paper? Bueller? My current shop likes to wing it and frankly that's not so good. I'd like to recommend something a little more standardized, and if I can ascertain what might be considered an industry standard, my suggestion might carry more weight. I've always been a pen and paper guy, doing data dictionaries first and determing relationships before committing to the DB. I'd like soemthing though, that is a bit more portable (and readable) than my chicken scratch. ~Tikiguy ~| 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:190705 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DB Survey
I've always been a pen and paper guy, doing data dictionaries first and determing relationships before committing to the DB. Me too :-) Until now, working on very small teams it hasn't be an issue; but I see your point. I'd like soemthing though, that is a bit more portable (and readable) than my chicken scratch. A few friends of mine love Case Studio. I've seen it in action and I think it may be worth a check: www.casestudio.com/ Massimo Foti DW tools: http://www.massimocorner.com CF tools: http://www.olimpo.ch/tmt/ ~| 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:190706 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
RE: DB Survey
Depends, sometimes use Erwin others DB Diagram others just simple queries and execution plans. -Original Message- From: Tiki Guy [mailto:[EMAIL PROTECTED] Sent: 17 January 2005 12:18 To: CF-Talk Subject: DB Survey Hi All, Just curious as to what applications people use when designing their DB's - Visio? Pen and Paper? Bueller? My current shop likes to wing it and frankly that's not so good. I'd like to recommend something a little more standardized, and if I can ascertain what might be considered an industry standard, my suggestion might carry more weight. I've always been a pen and paper guy, doing data dictionaries first and determing relationships before committing to the DB. I'd like soemthing though, that is a bit more portable (and readable) than my chicken scratch. ~Tikiguy ~| 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:190707 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DB Survey
ER/Studio, hands down: http://www.embarcadero.com/products/erstudio/erdatasheet.html We use ER/Studio in our Advanced Database course to teach people what we call our layered approach to designing and developing solid databases, and we couldn't effectively do that without it. There are so many important inner details that people will miss when they only have the front face of a pencil diagram to prompt them. Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 - Original Message - From: Tiki Guy [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, January 17, 2005 7:18 AM Subject: DB Survey Hi All, Just curious as to what applications people use when designing their DB's - Visio? Pen and Paper? Bueller? My current shop likes to wing it and frankly that's not so good. I'd like to recommend something a little more standardized, and if I can ascertain what might be considered an industry standard, my suggestion might carry more weight. I've always been a pen and paper guy, doing data dictionaries first and determing relationships before committing to the DB. I'd like soemthing though, that is a bit more portable (and readable) than my chicken scratch. ~Tikiguy ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190708 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
Re: DB Survey
I've been using ERStudio for 4+ years. Love it! Greg On Mon, 17 Jan 2005 08:30:52 -0500, Adam Churvis [EMAIL PROTECTED] wrote: ER/Studio, hands down: http://www.embarcadero.com/products/erstudio/erdatasheet.html We use ER/Studio in our Advanced Database course to teach people what we call our layered approach to designing and developing solid databases, and we couldn't effectively do that without it. There are so many important inner details that people will miss when they only have the front face of a pencil diagram to prompt them. Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 - Original Message - From: Tiki Guy [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, January 17, 2005 7:18 AM Subject: DB Survey Hi All, Just curious as to what applications people use when designing their DB's - Visio? Pen and Paper? Bueller? My current shop likes to wing it and frankly that's not so good. I'd like to recommend something a little more standardized, and if I can ascertain what might be considered an industry standard, my suggestion might carry more weight. I've always been a pen and paper guy, doing data dictionaries first and determing relationships before committing to the DB. I'd like soemthing though, that is a bit more portable (and readable) than my chicken scratch. ~Tikiguy ~| 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:190710 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
RE: DB Survey
Where's the decimal point go in the price tag? Makes me nervous when you have to contact the mfg for pricing... Dave Merrill ER/Studio, hands down: http://www.embarcadero.com/products/erstudio/erdatasheet.html We use ER/Studio in our Advanced Database course to teach people what we call our layered approach to designing and developing solid databases, and we couldn't effectively do that without it. There are so many important inner details that people will miss when they only have the front face of a pencil diagram to prompt them. Respectfully, Adam Phillip Churvis ~| 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:190711 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DB Survey
Yes.. I second caseStudio very good tool.. and love the fact you can reverse engineer the DB. Only thing I hate is RE is not supported on MSSQL 7. Massimo Foti wrote: I've always been a pen and paper guy, doing data dictionaries first and determing relationships before committing to the DB. Me too :-) Until now, working on very small teams it hasn't be an issue; but I see your point. I'd like soemthing though, that is a bit more portable (and readable) than my chicken scratch. A few friends of mine love Case Studio. I've seen it in action and I think it may be worth a check: www.casestudio.com/ Massimo Foti DW tools: http://www.massimocorner.com CF tools: http://www.olimpo.ch/tmt/ ~| 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:190715 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
Re: DB Survey
Just curious as to what applications people use when designing their DB's - Visio? Pen and Paper? Bueller? My current shop likes to wing it and frankly that's not so good. I'd like to recommend something a little more standardized, and if I can ascertain what might be considered an industry standard, my suggestion might carry more weight. ERwin and Embarcadero could both be considered industry standard. We use a home-grown web app - Flash diagramming tool on the front end, integrates with our CMS at the back, generates MySQL, SQL Server, Oracle databases. Couldn't live without it. Nick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190719 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DB Survey
First run: Pencil or Pen and usually scrap paper Second run: Visio model Third run: Pencil or Pen on printed visio model paper Fourth and final run: My brain, as i go over EVERYTHING to make sure it all makes sense. after that, any changes are looked at with utter disgust, as i shoulda found that to begin with ;) tw On Mon, 17 Jan 2005 09:24:50 -0500, Umer Farooq [EMAIL PROTECTED] wrote: Yes.. I second caseStudio very good tool.. and love the fact you can reverse engineer the DB. Only thing I hate is RE is not supported on MSSQL 7. Massimo Foti wrote: I've always been a pen and paper guy, doing data dictionaries first and determing relationships before committing to the DB. Me too :-) Until now, working on very small teams it hasn't be an issue; but I see your point. I'd like soemthing though, that is a bit more portable (and readable) than my chicken scratch. A few friends of mine love Case Studio. I've seen it in action and I think it may be worth a check: www.casestudio.com/ Massimo Foti DW tools: http://www.massimocorner.com CF tools: http://www.olimpo.ch/tmt/ ~| 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:190721 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: DB Survey
I use ER/Studo from Embarcadero. www.embarcadero.com I've used it for years at the two places I have worked. It is extremely scriptable, but you should just try it. It is a bit expensive, however, but worth the price. -Original Message- From: Tiki Guy [mailto:[EMAIL PROTECTED] Sent: Monday, January 17, 2005 6:18 AM To: CF-Talk Subject: DB Survey Hi All, Just curious as to what applications people use when designing their DB's - Visio? Pen and Paper? Bueller? My current shop likes to wing it and frankly that's not so good. I'd like to recommend something a little more standardized, and if I can ascertain what might be considered an industry standard, my suggestion might carry more weight. I've always been a pen and paper guy, doing data dictionaries first and determing relationships before committing to the DB. I'd like soemthing though, that is a bit more portable (and readable) than my chicken scratch. ~Tikiguy ~| 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:190727 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
Re: DB Survey
Single-platform is cheap, around $600 or $800 if memory serves me correctly, but the multi-platform version that handles all database platforms (the one we use) was $2,500 plus $750 for the first year's maintenance, which you had to buy, so it was a total of $3,250 for the initial purchase. This may seem like a lot of money, but I can tell you that it is the most cost-effective purchase I've made for my business over the past twenty years, and it has resulted in better software for our customers. Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 - Original Message - From: Dave Merrill [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, January 17, 2005 9:14 AM Subject: RE: DB Survey Where's the decimal point go in the price tag? Makes me nervous when you have to contact the mfg for pricing... Dave Merrill ER/Studio, hands down: http://www.embarcadero.com/products/erstudio/erdatasheet.html We use ER/Studio in our Advanced Database course to teach people what we call our layered approach to designing and developing solid databases, and we couldn't effectively do that without it. There are so many important inner details that people will miss when they only have the front face of a pencil diagram to prompt them. Respectfully, Adam Phillip Churvis ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190732 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DB Survey
I've been using Database Design Studio from http://www.dds-lite.com/ They have 2 versions Lite ($100) and Pro ($400). -Marty On Mon, 17 Jan 2005 08:18:09 -0400, Tiki Guy [EMAIL PROTECTED] wrote: Hi All, Just curious as to what applications people use when designing their DB's - Visio? Pen and Paper? Bueller? My current shop likes to wing it and frankly that's not so good. I'd like to recommend something a little more standardized, and if I can ascertain what might be considered an industry standard, my suggestion might carry more weight. I've always been a pen and paper guy, doing data dictionaries first and determing relationships before committing to the DB. I'd like soemthing though, that is a bit more portable (and readable) than my chicken scratch. ~Tikiguy ~| 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:190733 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
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 On Mon, 17 Jan 2005 09:39:52 -0500, Tony Weeg [EMAIL PROTECTED] wrote: First run: Pencil or Pen and usually scrap paper Second run: Visio model Third run: Pencil or Pen on printed visio model paper Fourth and final run: My brain, as i go over EVERYTHING to make sure it all makes sense. after that, any changes are looked at with utter disgust, as i shoulda found that to begin with ;) tw -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com ~| 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:190766 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DB Survey
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 ~| 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:190774 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: DB Survey
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
Re: DB Survey
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. Amen -- even with our favorite tool, ER/Studio. For example, if you need to enforce some referential integrity through DRI (constraints) and some through PRI (triggers), you'll need to hand edit the script generated from the tool. I *never* go directly from tool to database for that reason. Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ~| 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:190810 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DB Survey
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 -, 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