what are some of the better or common design tools most developers use for creating visual database diagrams/schemas etc... so far I looked into Xcase. Any others? it's all good
I use ERwin v4. With it I not only create and maintain logical datamodels, but also physical ones. You can design SQL Server databases, Oracle and IBM DB2/UDB. With ERwin you can compare models to each other or models directly to the database. If any differences are found, these can be routed to a change script and applied to either model or database. The only problem I have with it is: it does not recognize SQL Server 2000 functions when reading de systemtables, nor can I describe them myself in de model. Instead I model them in procedures with the CREATE FUNCTION text.
I'm just in the process of evaluating Embarcadero ER/Studio for a software review here. It seems to be a good tool for the job. -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Heute schon gebloggt?http://www.insidesql.de/blogs
I think ER is a good tool. I am not sure whether we have that many tools in our spotlight section on database design tools ----------------------------------------
