Hello:
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?
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
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.