Hello,
are there free, recommendable Tools for data modeling?
- ERM/ORM Diagrams
- Creating database models (SQL SERVER 2005)
- As Simple to use as Visio(no license here)
- Code generation is only a nice to have (VB.Net)
views:
76answers:
2
+1
A:
Give MySQL-Workbench a try, it's free:
http://www.mysql.de/products/workbench/
Anyway, it might not be quite what you want. If you could be bothered spending some money, try Visual Paradigm:
http://www.visual-paradigm.com/
A great all-rounder
Thank you. MySQL-Workbench has no ms sql server support and no code generation for .net. No major issues but as you said "not quite what i want". Visual Paradigm is not free and the community edition is for non-commercial use only. But i wil have a look at it.
Tim Schmelter
2010-05-19 08:45:05
With MySQL-Workbench, you could create a MySQL-Script and, with slight modification, turn it into a MS-SQL-Script to create your tables. But you are right, no code generation capability. Visual Paradigm: Yes, you would have to buy the commercial edition, but, believe me, it's worth!
2010-05-19 09:00:15
+1
A:
Paper and pen. Sorry ;) Thre really is not too much.
SQL Server has (not too good but not too bad) diagramming capabilities integrated. Code generation is always bad (what for, please - plus code generation only properly works the other way, starting with an object model, except you do plan to never use proper inheritance = bad programming model).
TomTom
2010-05-19 08:53:33
Redundant code is stupid. Code generation if often the automatism of redunand code. I personally call that stupidity suqared. Look at tools like NHibernate - they manage to live without generating hugh amounts of code. THere are some uses for code generation - data access normally is not one of them.
TomTom
2010-05-19 09:13:12
+1 because its more or less free and better than nothing. But paper doesn't blush and its almost as volatile as some agreements are.Without all the database and code generation stuff, what tools are free to design ER/ORM-Diagrams to visualize relationships so that even my chief understands it?
Tim Schmelter
2010-05-19 13:53:35