Data Modeling

  • Can anyone suggest a data modeling tool for SQL tables?

    None of our tables have foreign keys implemented in the database (long story) so I'll probably have to diagram the relationships manually, so does anyone know a good tool that easily does that?

    Thanks.

    The Redneck DBA

  • I usually use Visio for this.  If you are MSDN subscriber, it is included, and has Reverse Engineer utility to import your current database.

    Hope this helps



    Mark

  • Use Quest DataModeller they have good options there. I have used it.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • Lot's of options just depends on the featurs you will need and the cost you are willing to put out. Visio works fine for my needs.

  • You could also use ERWIN data modeller from CA.

    You can chk out features from all those and choose it.

  • My favorite and one I've been using for the last seven years or more, is PowerDesigner from Sybase.  It's a mature and well rounded product but far from cheap.  There are a lot of neat products out there but I've found you tend to get what you pay for.  The most important aspect would be identifying the features you need and then comparing those products that include those features. 

    Just my $.02

    James.

  • I've been evaluating ER/Studio from Embarcadero...nice UI.

    Anthony

  • redgate's "sql dependency"

    http://www.red-gate.com/products/SQL_Dependency_Tracker/index.htm

    It's great, but for large databases (i.e thousands of tables) it chews up graphics memory and slows your system. - best used with about 50 tables max

    it will also display dependencies between procs views etc

    MVDBA

  • Someone else suggested Computer Associate's Erwin diagram tool.  I ditto this as it has a great feature I really enjoy using.  Once you model your database, you can reverse engineer it into an actual database.  It also has a Complete Compare tool which allows you to update the diagram based on your current database config or vice versa. 

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • My choice, and affordable, is Enterprise Architect (http://www.sparxsystems.com/). Can do much more than just the DB diagrams, but the Pro version does the database very well. Once I tried this I wouldn't ever deal with Visio again.

  • Not a great tool, but one that at least give you a start.   Diagrams in Enterprise Manager work. 

  • If you're just going to do a one-time diagram, you could download a free trial of Visio 2007 Professional from here:

    http://us1.trymicrosoftoffice.com/product.aspx?re_ms=oo&family=visioprofessional&culture=en-US

  • Bob, the OP stated that they did not have relationships in the database.

    If you create a diagram in EM and draw a relationship, it will actually create the relationship in the database - don't think that's what the OP wanted to do.

  • I've used Visio, ERWin, ER/Studio, and quite a few others.

     

    By far, ER/Studio is the best tool out there.  Embarcadero has a free trial available for it... or at least they did the last time I looked.  You can reverse engineer the existing database and then draw all the relationships you want.

  • Jason, how are you going to approach modeling the db if there are no FK's?

    I have a similar situation, working with the Microsoft Retail Management System (RMS) and was wondering if you have a game plan, or just going to figure it out as you go.

Viewing 15 posts - 1 through 15 (of 18 total)

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