Results 1 to 11 of 11
  1. #1
    Join Date
    Jan 2004
    Location
    Austin
    Posts
    62

    Recommend a cheap data modeling tool?

    Looking for a tool which can replace ERWin.
    I've used ER Studio in the past, but this tool is also very expensive. More than 3K USD.

    I've played with DBDesigner Fork and Oracle Data modeler, but find they don't have some useful feature such as.

    Subject area division of model.
    Easy flip between logical and physical model.
    Adding tables related to a selected table to the view.
    Ease of table adjustment on the screen.
    Speed, surprised at how slow they are...

    Any ideas would be much appreciated.

    Mike
    Last edited by PanamaMike; 01-21-11 at 19:18.

  2. #2
    Join Date
    Jan 2011
    Posts
    14
    Maybe this link can help?

    Data Modelling Tools

  3. #3
    Join Date
    Mar 2011
    Posts
    4
    Hi,

    visit http://www.toad-data-modeler

    Toad Data Modeler is available in commercial and freeware versions.

    Veef

  4. #4
    Join Date
    Apr 2010
    Location
    London, England
    Posts
    24

    I recommend Dezign

    Dezign has pretty much everything you are looking for and it's very affordable, starting with a Standard Edition at $129.
    You can download a 30-day FREE trial -
    Download DeZign for Databases Free Trial Version

    HTH

    Barry Williams
    Database Answers
    London, England

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Users may care to take note that pai1009 is almost certainly promoting their or their employers product. That doesn't infer anything good, bad or indifferent about that product just that its possibly a stealth advert
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    I'd recommend checking out this comparison of Data Modeling tools as a representative sample of popular tools. I have had good luck with ModelRight and it strongly resembles ER-Win before it was purchased by Logic Works (for a good reason), but not everyone needs that kind of fire power.

    If you are looking to document a model instead of diagram or edit that model, I would strongly recommend using SQL-Spec. I can't say enough good things about this tool. Fair disclosure: the author of SQL-Spec is an old friend of mine, but I have no business relationship other than being a very happy customer.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  7. #7
    Join Date
    Feb 2017
    Posts
    1
    I suggest www.QuickDatabaseDiagrams.com [Disclaimer - I made it]

    It's the quickest, slickest way to design a database: just type! And it's free

    Click this thumbnail for a gif of it in action (I don't know why DBForums makes the thumbnail so small)
    Click image for larger version. 

Name:	QuickDBD amination.gif 
Views:	3 
Size:	283.3 KB 
ID:	17286

    It's not a full modelling tool: it doesn't yet generate DDL but I'm working on that. It is however an incredibly quick and easy way to design your model.

    (I'd also really appreciate any feedback or feature requests. Thanks)
    Last edited by TrevorJobling; 02-21-17 at 15:53. Reason: Trying to fix image attachment

  8. #8
    Join Date
    Aug 2017
    Location
    South Africa
    Posts
    12
    I use max3ds it pretty good , il admit i dont have much experience with any other programs of the sort , just putting out another option there for you.

  9. #9
    Join Date
    Nov 2003
    Posts
    2,993
    DbSchema is pretty good and not too expensive.

    https://www.dbschema.com/index.html
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  10. #10
    Join Date
    Aug 2017
    Location
    South Africa
    Posts
    12
    Quote Originally Posted by shammat View Post
    DbSchema is pretty good and not too expensive.

    https://www.dbschema.com/index.html
    Hi Shammat , is this a free resource ?

  11. #11
    Join Date
    Nov 2003
    Posts
    2,993
    Quote Originally Posted by petershene View Post
    Hi Shammat , is this a free resource ?
    As I have written: it is a commercial product, but it's not very expensive
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •