776
General Software Discussion / Re: Database Design Software
« Last post by steeladept on May 12, 2008, 04:16 AM »Thanks for the info. I kept looking and found one that looks promising, though I am pretty well stuck with MySQL if I go this route. It is called DB Designer 4 from fabForce.net. I just started playing with it and it looks very professional, yet very easy to use thusfar. It also supports some of the drawbacks you mentioned such as cascade on update/delete rules for foreign keys. The rest I am not sure about though, and I haven't tried the actual database creation yet, since I am still trying to define a table or two. Some tools seem simplistic, but most are readily available. For example, I can't copy a field and make it field2 with the same properties. On the plus side, with support for enumerated types and sets, I may not need that. Well that and I can always type it manually 
I will check out Power*Architect soon as the web/interface programming will either be in Java or C# (depending on the system I use, as these are the two languages I know best). My one question though, for any of these tools, since they tend to be designed for integration with specific databases (via support for the data-types), what happens when you use an ODBC/JDBC driver to connect to a different DB? For example, MySQL supports the aforementioned SET and ENUM data-types, but OoBASE does not. If I were to try to use the driver to make that connection, does the driver translate the data-type to a primative that the RDBMS can understand, or does it just blow up?

I will check out Power*Architect soon as the web/interface programming will either be in Java or C# (depending on the system I use, as these are the two languages I know best). My one question though, for any of these tools, since they tend to be designed for integration with specific databases (via support for the data-types), what happens when you use an ODBC/JDBC driver to connect to a different DB? For example, MySQL supports the aforementioned SET and ENUM data-types, but OoBASE does not. If I were to try to use the driver to make that connection, does the driver translate the data-type to a primative that the RDBMS can understand, or does it just blow up?

Recent Posts



