Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Database Diagrams Expand / Collapse
Posted Thursday, November 29, 2007 1:54 PM


Group: General Forum Members
Last Login: Yesterday @ 2:35 PM
Points: 195, Visits: 384
In our organization, we are using SQL Server 2005 Management studio as the client interface to access all our enterprise Databases.Most of the databases are built on SQL 2005 DB Server.

However, We have one of the Database built on SQL Server 2000, which also has Database diagrams in it. Though We are able to view all the DB objects through SQL 2005 managment studio interface, but unable to view the diagrams.
I understand that, the binary data of the diagrams are stored in "dtproperties" table on SQL 2000 but in SQL 2005, it is stored in "sysobjects"(not sure) table and both are entirely different.

Following are my questions.

1.Since the DB is still on SQL 2000,How can we view the diagram objects thru the SQL 2005 Enterprise manager.

2.For the migration process of SQL 2000 to SQL 2005, How can i migrate the database diagrams.

Looking forward for help on this.


Post #427776
Posted Thursday, November 29, 2007 2:25 PM

Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 16, 2016 12:13 PM
Points: 1,326, Visits: 1,349
Hi satishchandra,
From bol

SQL Server 2005 database diagrams and SQL Server 2000 database diagrams are created and rendered differently. 
Because of these differences, SQL Server Management Studio cannot work with SQL Server 2000 diagrams. Use SQL Server 2000 Enterprise Manager.

When a database containing diagrams is upgraded to SQL Server 2005, the diagrams will be upgraded the first time that the diagrams folder is opened.

You must be a member of the db_owner database role to upgrade database diagrams.

Post #427788
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse