Post reply

Database Diagrams

  • November 29, 2007 at 1:54 pm

    #201364

    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

  • November 29, 2007 at 2:25 pm

    #755694

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply