Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Diagrams Expand / Collapse
Author
Message
Posted Thursday, November 29, 2007 1:54 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 28, 2014 10:05 AM
Points: 177, Visits: 355
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.

Thanks

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: Friday, July 25, 2014 12:42 PM
Points: 1,326, Visits: 1,282
Hi satishchandra,
From bol

http://msdn2.microsoft.com/en-us/library/ms186552.aspx

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.

Regards,
Ahmed
Post #427788
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse