SQL Server Performance

best of breed database design tool ?

Discussion in 'Third Party Tools' started by kingofSQL, Jun 15, 2006.

  1. kingofSQL New Member

    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
  2. Datei02 New Member

    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.
  3. peterlemonjello New Member

  4. FrankKalis Moderator

  5. dineshasanka Moderator

    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

    ----------------------------------------

Share This Page