Import Diagrams and relations - SQL Server Forums

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 2000 Forums

SQL Server Administration (2000)

Import Diagrams and relations

Author

Topic

arturos
Starting Member

7 Posts

Posted - 2005-04-14 : 18:56:37

I want to know how import diagrams and relations between databases, in this case usging the same server

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-04-14 : 19:02:28

Diagrams:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125

To move PKs and FKs, you can use the generate SQL script wizard which can be found by right clicking on the database, all tasks, generate SQL script. Make sure to go to the third tab to specify that you want the keys. Then copy this script into Query Analyzer, connect to the database that you want to copy to and run the script.

Tara

arturos
Starting Member

7 Posts

Posted - 2005-04-14 : 19:30:30

Tara thanks.
I did everything and PKs and FKs were transfered, but diagrams I have
to run this query fomr Query Analyzer, (This is for one diagram)

INSERT SysData..dtproperties
SELECT objectid, property, value, uvalue, lvalue, version
FROM SysItochuTest..dtproperties
WHERE objectid = (SELECT objectid FROM SysItochuTest..dtproperties WHERE value='Inventory')

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources