January 3, 2006 at 3:48 pm
I have database diagrams in SQL Srever 2000 and want to move them to 2005. In SQL Server 2000 diagrams meta-data is stored in dtproperties quasi-system table.
I created dtproperties table in SQL Server 2005 using SQL script generated from 2000, BCPed out/in its data, but SQL Server 2005 does not seem to recognize this (probably) obsolete table. Instead it has sysdiagrams table which has completely different design.
Does anybody knows the way to move the diagrams ? Upgrade won't work because there is no return back to 2000.
Thanks
January 4, 2006 at 9:49 am
In the Dec 2005 updated Books Online, look for "diagrams [SQL Server], upgrading" in the index.
It says, "Database diagrams created on previous editions of SQL Server databases are upgraded automatically when database diagramming is set up on Microsoft SQL Server 2005."
It sounds like the previous edition diagrams are converted (and therefore must already be in the database) when diagramming is enabled. It doesn't say anything about how to convert them if you copy the dtproperties table later.
There is a reference to a "sp_upgraddiagrams" stored proc, but it seems to be undocumented. I Googled it but only learned that it is one of a few system procs installed with no execute permissions.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply