hi all;
is it possible to copy diagram in one database to another database? while
there structure of both dbs are same.
I have not found any option in DTS top copy diagrams only.
any suggestion? thanks in advance.
ansariHi,
All the diagrams for a database will be stored in table dtproperties. So you
could load the destination database 'dtproperties table' with source
contrents.
See the links.
http://groups.google.co.in/groups?q=copy+sql+server+diagrams+to+a+new+server
&hl=en&lr=&ie=UTF-8&selm=39A5A042.38D3D1FF%40ietsmet.nl&rnum=8
http://www.mssqlserver.com/faq/transfer-diagrams.asp
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125
Thanks
Hari
MCDBA
"M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
news:u66VLGtcEHA.2268@.TK2MSFTNGP12.phx.gbl...
> hi all;
> is it possible to copy diagram in one database to another database? while
> there structure of both dbs are same.
> I have not found any option in DTS top copy diagrams only.
> any suggestion? thanks in advance.
> ansari
>
>|||thanks hari
ansari
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uE2R5atcEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Hi,
> All the diagrams for a database will be stored in table dtproperties. So
you
> could load the destination database 'dtproperties table' with source
> contrents.
> See the links.
>
http://groups.google.co.in/groups?q=copy+sql+server+diagrams+to+a+new+server
> &hl=en&lr=&ie=UTF-8&selm=39A5A042.38D3D1FF%40ietsmet.nl&rnum=8
> http://www.mssqlserver.com/faq/transfer-diagrams.asp
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125
>
> Thanks
> Hari
> MCDBA
> "M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
> news:u66VLGtcEHA.2268@.TK2MSFTNGP12.phx.gbl...
> > hi all;
> >
> > is it possible to copy diagram in one database to another database?
while
> > there structure of both dbs are same.
> > I have not found any option in DTS top copy diagrams only.
> >
> > any suggestion? thanks in advance.
> >
> > ansari
> >
> >
> >
> >
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment