I used MS DTS to transfer database from MS SQL 7.0 to MS SQL 7.0. It
worked. But, the datasbe diagrams were not transfered. How can I transfer
Post it here if you get the chance!
We have succeeded in transferring diagrams from one database to another,
except for one thing: the diagram links layout.
Here's what happens:
The source diagram has a particular layout... after copying the diagram to
the target database, I
open the diagram and initially, as it's building up the tables and
links, they are laid out in exctaly the same way as in the source
diagram. GREAT... but as soon as all the objects on the diagram are
displayed, the links are redrawn to their defaults, which messes up the
layout entirely (tables, on the other hand, stay in place).
Something tells me that the initial layout is saved along with the
diagram definition but some flag invokes some kind of "auto-arrange
Does anyone know more about this?
Thanks a lot in advance.
TEA Software Development Division