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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How to import Diagram

Author  Topic 

Peace2007
Posting Yak Master

239 Posts

Posted - 2009-01-25 : 01:33:27
Hi,

Du to changing SQLserver in our company, I've imported all databases to the new server; but the diagrams didn't imported!

Could you let me know how I can import diagrams?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-25 : 01:41:10
So you didn't do a backup/restore?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Peace2007
Posting Yak Master

239 Posts

Posted - 2009-01-25 : 01:48:38
I did but no diagram is restored!!
I did as http://support.microsoft.com/kb/320125 said as well but it cannot parse dtproperties
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-25 : 01:50:20
To answer your question though, you can move them through T-SQL. If the databases are on separate servers, you'll need to use a linked server with the four-part naming convention. The table that has the data is sysdiagrams.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-25 : 01:51:00
dtproperties is a SQL Server 2000 thing.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Peace2007
Posting Yak Master

239 Posts

Posted - 2009-01-25 : 02:00:13
I cannot create linked server cause one is 32 bit and the other one is 64 bit
is there any other solution?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-25 : 05:03:03
http://marcellotonarelli.wordpress.com/2008/03/16/moving-a-database-diagram-in-sql-server-70-and-sql-server-2000/
Go to Top of Page
   

- Advertisement -