Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have some SQL Server databases and use SQL Server Management Studio to manage them.

However, I find that is not very friendly to create, design and print database diagrams (for existing tables).

What (freeware, if possible) software do you know to be more user-friendly from this point of view?


migration rejected from Feb 14 '14 at 5:30

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Paul White, ypercubeᵀᴹ, Mark Storey-Smith, RolandoMySQLDBA, Max Vernon Feb 14 '14 at 5:30

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, ypercubeᵀᴹ, Mark Storey-Smith, RolandoMySQLDBA, Max Vernon
If this question can be reworded to fit the rules in the help center, please edit the question.

Did you try "Toad for Sql Server"? – Pablo Claus Nov 29 '12 at 13:37
"user-friendly" is vague. What do you want to do? – madth3 Nov 29 '12 at 16:52

I would encourage you to try Oracle SQL Developer Data Modeler even if you are working with SQL Server. Its free and you can create models for Oracle, SQL Server and DB2.

I like the data modeler from Oracle. It's not Erwin but it can do a lot of what you need – kevinsky Nov 29 '12 at 19:59

Try Toad for Sql Server

They have a freeware version.

Toad won't let me connect to Azure SQL. What a waste of time – DeepSpace101 Feb 9 '13 at 2:49
Downloaded the 100MB package, installed, connected to my server, tried to create a model for two tables - error. – DWRoelands May 9 '14 at 18:02

Consider the free Schema Surf for SQL Server from Atlantis Interactive.

enter image description here