Post reply

Good, free, simple database modelling tools

  • March 23, 2015 at 9:00 am

    #316348

    Hello

    Are there any good, free, simple database modelling tools out there?

    I'm not really after something that can create and synch databases with version control and all the other bits and pieces that full blown development teams might want to use etc. etc.

    At this stage, all I really want is something simple that I can connect to a SQL Server database, and automatically generate a model with.

    Does anybody have thoughts on how to achieve this?

    Thanks

    - Damian

  • March 23, 2015 at 11:45 am

    #1785788

    Database diagrammer in SSMS

  • March 25, 2015 at 8:18 am

    #1786327

    Thanks

    I'll look further into SSMS although doesn't that dynamically modify the table?

    - Damian

  • March 25, 2015 at 9:11 am

    #1786341

    CA ERwin has a free tool now, although that version does limit the number of objects. The full ERwin is a fantastic modeling tool (my favorite of the many I've used). I haven't used the free version, but presumably it's similar to the enterprise version.

    I believe Oracle also has a free tool (they finally killed their for-pay DM tool after it limped along for a while). I've never used it, and it may be limited to generating for Oracle (or it may not, I'm not sure). But converting the logical model to a physical model is easier than the logical design anyway, so you can live with it even if it doesn't generate T-SQL.

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

Viewing 4 posts - 1 through 3 (of 3 total)

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