{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 Explosion°爆炸 的问题《A good database modeling tool? [closed]》','https://www.manongdao.com/q-1307914.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
Could you guys recommend me a good db modeling tool? Mainly for SQL Server...
thanks!
标签：
database-design
相关问题
- How to better organise database to account for cha
- Database best practices - Status
- Designing lossless-join, dependency preserving, 3N
- Use of empty strings instead of null - a good prac
- Shared Primary Key
相关文章
- Storing User Settings - anything wrong with using
- Are PostgreSQL VIEWS created newly each time they
- What is the difference between UNIQUE, UNIQUE KEY
- Optional Database Entities
- TIme-based Notification Architecture
- The right way to manage user privileges (user hier
- How to salvage referential integrity with mutiple
- Inbreeding-immune database structure
ERwin Data Modeler is the best tool for Enterprise database modelling in my opinion. I've used it a number of times and it is great. See: http://www.ca.com/us/products/product.aspx?id=260
It is a little bit pricey, but it is worth it. You can also trial it for free.
I've been using for some time with great success what used to be called 'Case Studio'. It's now called 'Toad Data Modeller'..
It's pay, but quite good, worth at least a trial.
StarUML has a module that allows for the creation of Entity Relationship Diagrams. However, I've never used it for this purpose, so I don't know how good it is, but I do like StarUML for UML diagrams.
Funny as it is I've found:
WWW SQL Designer
to be useful in a pinch. I'm also a fan of his Instant SQL Formatter though by "instant" he means "not T-SQL" so you have to some slight hand editing of Profiler recorded statements to use his system fully.
If you mean for drawing Entity Relationship Diagrams, then I suggest Visio. It will even build your database from the Diagram.
Well, if you're using SQL Server, as I've mentioned in other posts Visio probably will work really well for you. You probably already have it or your IT shop does so the cost is negligible and it can import an existing database or if you build from scratch can export it to a designated SQL Server.
I've used it several times and have been happy with the results.