SQL Server Performance

Database Designing tools

Discussion in 'Third Party Tools' started by sachinsamuel, Apr 24, 2006.

  1. sachinsamuel New Member

    Hi Gurus:

    I am planning to design a database. Can anyone help me with the tools available for database design?

    My colleagues asking me to use ERwin or powerdesigner. Any comments on these tools?

    Thanks in advance

    Regards
    Sachin
  2. dineshasanka Moderator

    I think ERWin is a good tool. I am not sure whether it has support for SQL Server 2005. Vision is also a good tool. anyway, it not tailor made tool for database designing.

    ----------------------------------------
    http://spaces.msn.com/members/dineshasanka
  3. mmarovic Active Member

    Power Designer has really good user interface and it is intuitive. You can buy physical modeler and conceptual modeler (or something like that) separately. There are also uml modules and more. If you use both conceptual and physical modeler you can create conceptual model and generate physical model for each dbms you want to support. Also, you can propagate each model change back to conceptual model. The tool can also generates change scripts each time you change the model. With version 9.0 you had to review scripts and occasionally fix them. Current version is 11 or 12, I am not sure.

    ERWin I haven't used for a long time, but I think it has the same advantages as PowerDesigner.
  4. satya Moderator

    You can use either of above referred tools and for the review of those tools may need to search on Google or under third party tools articles in this website.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. sachinsamuel New Member



    Thanks you all for your feedback.

    Regards
    Sachin
  6. druer New Member

    The following link contains a brief review of many of the top tools as of 2000:<br /<a target="_blank" href=http://www.aisintl.com/case/products/product.html>http://www.aisintl.com/case/products/product.html</a><br /><br />Power Designer is not highly recommended, and I would probably not put my recommendation behind it simply because in my younger years I had written a data/process modeling product called Vivid Clarity. The following link is from someone obviously well versed in tools at the time (1995) who accurately identified that the Power Designer tool basically stole our interface and design immediately after we went out of business. I probably should be flattered, but my intrinsic problem was that our company InTek had demonstrated the product multiple times for Powersoft because ours was the first and only tool that actually generated working application prototypes in PowerBuilder. They had no interest in helping us market the product at all. I guess so that they could then copy it once our venture capital was dried up.<br /><br /<a target="_blank" href=http://www.aisintl.com/unclassified/02Oct95.html>http://www.aisintl.com/unclassified/02Oct95.html</a><br /><br />Of course based on the review as of 2000, maybe I should contact Sybase/Powersoft and let them know that I'm available for a price. <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />Good luck in your tool choice (just consider the rantings of another 90's developer with millions of shares of useless stock),<br />Dalton<br /><br />Hope it helps,<br />Dalton<br /><br />Blessings aren't so much a matter of recieving them as they are a matter of recognizing what you have received.
  7. mmarovic Active Member

    Dalton,

    if your design included also very intuitive diagram elements handling, then congratulations! This is great user interface and great design.
  8. Luis Martin Moderator

    I've moved to relevant forum.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



Share This Page