ER Diagrams

Hello.

Historically SQL server has shipped with a simple but extraordinarily effective database diagramming tool. For me its one of the compelling features that differentiates SQL from mySQL or postrgres.

SQL Server Express Edition does not seem to include a diagramming tool. Is it possible to use one of the other express editions to create diagrams or is there another way to do this

Thanks for taking the time to respond.

renen.



Answer this question

ER Diagrams

  • abwebsvcs

    Hi,

    you may create ERM with a third party tool. But as I know SQL Server express is called so, because it is only a light version.

  • Schtrudel

    If you're talking about the SQL Server 2000 Diagrams feature, you can create a diagram using any of the Express products. To do this, create a Windows Forms or ASP.NET Project, in the Solution Explorer, click Add New Item... and add a SQL Database, (ex: Database1). After you add your new database, Click View..."Database Explorer", expand Database1, and select the "Database Diagram" feature to create a diagram of your database.

    Thanks,
    Dan Fernandez
    Product Manager
    http://blogs.msdn.com/danielfe/ 


  • ER Diagrams