Diagram a New Database for an ASP.NET Application? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 7 years ago.

Improve this question

I'm about to create a new application - somewhat like a CRM. I'm thinking it would be best to diagram out all the tables/fields before I begin...but not sure w开发者_Go百科hat is the best way to do so? Are there tools in VS? MSSMS? Something else? I want to quickly and thoroughly create the database the application will use for its back-end.

---

This http://msdn.microsoft.com/en-us/library/ms171971%28VS.80%29.aspx article explains pretty well how to create database diagrams using Microsoft SQL Management Studio. You can download SQLMS here: http://www.microsoft.com/express/Database/

The nice thing about this approach is that your diagram is also your database so you don't have to create the diagram and then create the database, you can get them both done at the same time.

---

I quite like to use Microsoft Visio to map this sort of stuff out.

Or even better - a wipeboard!

---

You can do this inside Visual Studio. Just set up a Database and in the Server Explorer, create a new diagram. The way to do this differs in different VS Versions.

VS 2005

Another approach would be to use the Management Studio Express

You can get this one here.