How to: Upgrade Database Diagrams from Previous Editions

Database diagrams created on previous editions of SQL Server databases are upgraded automatically when database diagramming is set up on Microsoft SQL Server 2005. For more steps for setting up diagramming see How to: Set Up Database Diagram Designer.

Note

The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.

To upgrade legacy database diagrams

  1. Create a database connection in Server Explorer using a member of the db_owner role to log in. For steps see How to: Connect to a Database from Server Explorer.

  2. Expand the Database Diagram node under the database connection.

  3. Select Yes when prompted if you want to set up database diagramming.

    This will upgrade diagrams stored on the database.

See Also

Tasks

How to: Set Up Database Diagram Designer

Concepts

Understanding Database Diagram Ownership