CODEWITHSUNDEEP
visual-studio
JMarsch
JMarsch

Reputation: 21751

New visual Studio 2010 Database project and database diagrams

I am experimenting with the database project in Visual Studio 2010. The schema diff and management of scripts looks great, but where are the database diagrams? I would like to design the tables visually, but still make use of the versioning/comparison/deployment tools in VS2010. I didn't see any option in the database project to create a diagram. Is that not supported?

Upvotes: 1

Views: 6504

Answers (3)

Scott Herbert
Scott Herbert

Reputation: 334

There certainly is diagramming support.

Open the "Server Explorer"

Create/open a data connection.

You should see "Database Diagrams", which will function very similarly to the same function in SQL Server Management Studio.

Bam.

Note, I'm referring to V2010 Ultimate.

Upvotes: 0

David Atkinson
David Atkinson

Reputation: 5909

You could create the diagrams in SSMS (or another diagramming/modelling tool) as you would do normally, and synchronize the structure back to your Visual Studio Database Project, although you'll need the Premium or Ultimate version of Visual Studio to use this feature.

Upvotes: 1

TimothyP
TimothyP

Reputation: 21765

I'm not sure if this is what you are looking for, but I suggest you add an Entity Diagram (Entity Framework) to your project / solution. This will allow you to design/describe your data model(s) either by drawing them visually or by importing an existing database schema.

Entity Framework information: http://msdn.microsoft.com/en-us/library/aa697427(VS.80).aspx

Tutorial (for EF 2.0 but still relevant) http://blog.garypretty.co.uk/index.php/2009/05/20/tutorial-entity-framework-v20-model-first-using-visual-studio-2010-and-net-40/

I hope this helps you get started

Upvotes: 0

Related Questions