Import diagram to SQL-server 2000
-
Is there any other easy way to import a diagram to an SQL-server 2000 DB than doing a restore of a backup? (Do not want to do a restore...)
Yes it is pretty simple. All database diagrams are stored in the table dtproperties. This link will show you the query you need to run. http://www.mssqlcity.com/FAQ/TranMove/MoveDiag.htm
-
Yes it is pretty simple. All database diagrams are stored in the table dtproperties. This link will show you the query you need to run. http://www.mssqlcity.com/FAQ/TranMove/MoveDiag.htm
Hmm I've tried both examples now and they all resulted in that a copy was created of an already existing diagram with exactly the same name(!). When I deleted one of the diagrams, SQL Enterprise Manager crashed every time I tried to look at a diagram... insert into Example..dtproperties (objectid, value, lvalue, version, property) select objectid, value, lvalue, version, property from Northwind..dtproperties where objectid = (select objectid from dtproperties where value = 'Relationships') You have to add "Northwind.." in the last statement. I don't see how to transfer diagrams from different servers, only between databases on the same server. Have I missed something?