Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
satishchandrat
Starting Member
1 Post |
 Posted - 2007-11-29 : 15:41:18
|
| 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.Appreciate the responses. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-30 : 02:41:06
|
| 1. You can't, use em instead.2. May copy to sysdiagrams table in sql2k5, test it. |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-11-30 : 08:01:55
|
on 2, i am pretty sure the binary format of diagrams changed between 2000 and 2005. you probably have to re-create the diagrams in 2005.
elsasoft.org |
|
|
|
|
|
|
DataBase Diagrams