| Author |
How can I copy a database diagram from one db to another
|
|
|
| The tables I need for the diagram have all been transferred using dts, Now I
need a copy of the diagram using these tables in the new db, There are
qwuite a few annotations in it that I don't want to have to ewrite.
Thanks for any help.
RD
| |
| Andrew J. Kelly 2005-07-25, 8:29 pm |
| http://www.mssqlserver.com/faq/transfer-diagrams.asp
--
Andrew J. Kelly SQL MVP
"Bob" <bdufournosp@sgiims.com> wrote in message
news:uXaTKyWkFHA.1444@TK2MSFTNGP10.phx.gbl...
> The tables I need for the diagram have all been transferred using dts, Now
> I need a copy of the diagram using these tables in the new db, There are
> qwuite a few annotations in it that I don't want to have to ewrite.
>
> Thanks for any help.
>
> RD
>
| |
|
| Thanks,but the origin db is on one server and the target db is on another
server first one is defined in my enterprise mgr by its ip address, second
one by its name (Max). and I'm working on a third in my E mgr. I got each
server in a different server group in my E mgr.
Tried it but getting an error.
Be grateful if you could help a bit more
RD
"Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
news:uFmet3XkFHA.2720@TK2MSFTNGP10.phx.gbl...
> http://www.mssqlserver.com/faq/transfer-diagrams.asp
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Bob" <bdufournosp@sgiims.com> wrote in message
> news:uXaTKyWkFHA.1444@TK2MSFTNGP10.phx.gbl...
>
>
| |
| Darren Green 2005-07-26, 3:24 am |
| Transfer dtproperties using DTS to cross servers easily.
--
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"Bob" <bdufournosp@sgiims.com> wrote in message
news:O18y8mYkFHA.4044@TK2MSFTNGP10.phx.gbl...
> Thanks,but the origin db is on one server and the target db is on another
> server first one is defined in my enterprise mgr by its ip address, second
> one by its name (Max). and I'm working on a third in my E mgr. I got each
> server in a different server group in my E mgr.
>
> Tried it but getting an error.
> Be grateful if you could help a bit more
> RD
> "Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
> news:uFmet3XkFHA.2720@TK2MSFTNGP10.phx.gbl...
>
>
|
|
|
|