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.
| Author |
Topic |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2002-10-07 : 10:58:46
|
| Hi Folks,Is it possible to move the database diagram from a database which is on a SQL Server 7.0 box to a database which is physically on an other box.ByeRamdasRamdas NarayananSQL Server DBA |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-07 : 12:18:43
|
| The diagram information is stored in the dt_properties table, but I can't say for certain that transferring that table's data will reconstruct the diagram exactly. It's better if you generate a real diagram with something like Visio or ErWin and use that as your official diagram; the SQL Server diagrams are an afterthought IMHO and not really useful. |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-07 : 12:50:10
|
| HOW TO: Move a Database Diagram[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125[/url]HTHJasper Smith |
|
|
|
ramdas
Posting Yak Master
181 Posts |
Posted - 2002-10-07 : 14:26:43
|
| Hi,Thanks for the link.ByeRamdas NarayananSQL Server DBA |
|
|
|
|
|
|
Database Diagram