Suggestions needed for Database Design Tools

  • Topic: Database design tools for MS SqlServer. Our developers have used Visio, SSMS Diagrammer, and t-sql long enough. They find these tools woefully inadequate for serious design (including datawarehsoue) and are complaining loudly. We also have datawarehouse developers interested in such a tool.

    We are reviewing Embarcadero's ER\Studio.

    1. Can anyone, with experience with that product, comment about it?

    2. As part of our tool comparison, can you recommend any other design tools on par with "ER\Studio"?

    TIA,

    Barkingdog

  • Over the years, I have used (but not for DW):-

    ErWin - good, but expensive

    ER/Studio - my favourite, but again, expensive

    Powerbuilder - OK, again expensive

    Visio - very slow, especially for large databases, no forward engineer unless you get the Enterprise Edition.

    SSMS Diagrammer - yuk

    I've also looked at a number of free tools, but discarded them, as there was always something missing from them (can't remember the names of most of them, as they ware discarded so quickly)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply