Is there a Database Diagram programes more powerful than that with MS SQL Server??

Question

As i described,

I want program give me more helpful diagram for example :

MS SQL Server Diagram didn't give you a good design for relations so if you have many relations in the same table then the diagram just draw many lines to your table and didn't set the lines to specific column that would confuse you if you have many tables and complicated Database.

Answer 1

Try MS Visio. I think that will fit your bill. A better alternate would be ERWIN.

Raj

Answer 2

You can drag the end points of the lines down to the individual keys. But if you move the table, they all move back up to the top of the table.

Answer 3

I have used ER/Studio for years. It works great but is quite expensive.

Answer 4

Here are three good ones I have used (from most expensive to cheapest)

• Computer Associates - ErWin
• Embarcadero - ER/Studio
• ModelRight

However, I will say that your problem is more or less inevitable with complicated databases and is better dealt with via good naming conventions than with lines on the diagram. If your column names are consistent it goes a long way towards readability.

Answer 5

Fabforce DBDesigner is a good one in the freeware section... optimized for MySQL.

Version 4.0 used to be buggy, but had more features than Version 5.0 which is now MySQL/SUN owned.

Try both versions.

Answer 6

Good naming conventions is always good, but sometimes the naming has evolved over the years and is what it is. Do you know if any of these tools has the feature to draw the lines to the right columns?

Answer 7

Hi guys!

I tried booth "MS Visio" and "Embarcadero ER/Studio" and they have many beautiful tools especially "Embarcadero ER Studio".

But the problem of relations lines between tables still didn't solve.

You know i want tool to give me just a graphical diagram that draw relation lines to correct fields not just the table but to the specific field."Like diagram in MS Access".