Database Diagram Migration | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Database Diagram Migration

Hi, I got information how to make work of Database diagrams in SQL Server2005, But i have a requirement that the DB diagram which i was using in Sql2000 can be transferred to SQL2005. Is it possible??? is there any link showing the details of this issue in BOL??? Mat

as far as i know, there is no option of migrating database diagram to sql server 2005 from sql server 2000 —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

Is it like that, you have any microsoft links which makes this 100% as i need to look for some options…
why this feature is missing???? Mat
BOL specifies
quote:
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 (Visual Database Tools). To upgrade legacy database diagrams
From Object Explorer, expand the database. Expand the Database Diagram node under the database. Select Yes when prompted if you want to

Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Read this thread…
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=12577
Mohammed U.
Thanks for the reply but when i applied the steps in the given thread and restarted the server, its giving an error when double clicking on the migrated database diagram object.given below is the error.. TITLE: Microsoft SQL Server Management Studio
—————————— Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (SQLEditors) ——————————
BUTTONS: OK
——————————
Mat
I suggest to post this feedback to Microsoft connect website, where it might be fixed in future release of hotfix or SP. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>