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 |
|
niemeyer
Starting Member
15 Posts |
 Posted - 2003-08-19 : 17:34:00
|
| When I use the DTS to copy a db from my local MSSQL to the remote server (connecting via IP address) everything is copied ok except the diagram laying out the relations. The table relations *are* copied because the damn thing works as expected also on the remote server.I figured out that the diagrams are saved in the sysfile 'dtproperties' but when copying using the DTS query tool from local to remote this table is not visible.I need to remove some relations on certain tables when bulk loading new data and was just wondering how I got to copy the diagram (as opposed to creating a new diagram on the remote server and adding relations manually).Thanks a lot for any ideas,Niels |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-08-19 : 17:48:58
|
| http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q320125or you can just create a linked server and insert from the remote dt_properties table.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
niemeyer
Starting Member
15 Posts |
Posted - 2003-08-19 : 18:21:34
|
| Thanks, Nigel, you rock!! It works perfectly :))// Niels |
|
|
|
niemeyer
Starting Member
15 Posts |
Posted - 2003-08-20 : 19:41:21
|
| I had a strange occurrence when copying the dtproperties file between the local and remote server.At first it seemed to work allright; the diagram emerged in the pane on the remote server and upon opening all the tables were lined up with all the relations as in the diagram on the local db. But after a few seconds the relations started to delete themselves in the diagram... I tried later to remove the 'enable identity insert' marker in the transformation window and then copy the table again. And now it seems to work...Was that the explanation? It's not mentioned anywhere in documentation I've been able to find, so can anyone here in the forums confirm that it is the solution?Thanks for an excellent forum!Niels |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-08-20 : 20:00:29
|
Sorry - you've already said it worked - you don't get a second chance  .I don't use the sql server diagrams - prefer to use something outside the server like ERWin or Visio or Word.The diagram is linked to the database structure so I guess that is causing the problem.Have any of the table IDs changed? I guess that might cause problems.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
niemeyer
Starting Member
15 Posts |
Posted - 2003-08-21 : 07:14:30
|
| Nope, none of the ID's has changed on the object copying. Its a little db of 10mb and the dtproperties table consists of 7 entries (id's 1-7) with the same object id (1). Anyway, this will not enter history as one of the great mysteries, so I think I'll try some of the solutions you advice. If I bump into the final answer I will flag it in the forums.Thanks,Niels |
|
|
|
|
|
|
Hidden diagrams?