Showing posts with label diagram. Show all posts
Showing posts with label diagram. Show all posts

Sunday, March 25, 2012

Copy diagram from one MSSQL db to another

Hallo,
The subj actually says it all. I have developed the database locally, and
added a nicley formatted diagram to it, and would like to spare the
possibility to remake it once again on another database that has exactly the
same structure. So, there must be some way to copy the diagram from here to
there. I'd appreciate if someone could hint me how that could be possible to
achieve.
Thank you,
-- PavilsThe following article explains how to do it:
HOW TO: Move a Database Diagram
http://support.microsoft.com/?id=320125
-Sue
On Tue, 2 Mar 2004 16:31:13 +0200, "Pavils Jurjans"
<pavils@.mailbox.riga.lv> wrote:

>Hallo,
>The subj actually says it all. I have developed the database locally, and
>added a nicley formatted diagram to it, and would like to spare the
>possibility to remake it once again on another database that has exactly th
e
>same structure. So, there must be some way to copy the diagram from here to
>there. I'd appreciate if someone could hint me how that could be possible t
o
>achieve.
>Thank you,
>-- Pavils
>|||Thanks, that works well. Luckily, I have only one diag to copy and the
destination database does not contain any diagrams. There could be
complications using this copy *.* approach on some finer cases.
-- Pavils
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:s279401gpnvhr8892a3s1gq7rsqoi4rnpl@.
4ax.com...
> The following article explains how to do it:
> HOW TO: Move a Database Diagram
> http://support.microsoft.com/?id=320125
> -Sue
> On Tue, 2 Mar 2004 16:31:13 +0200, "Pavils Jurjans"
> <pavils@.mailbox.riga.lv> wrote:
>
the
to
to
>sqlsql

Copy diagram from one MSSQL db to another

Hallo,
The subj actually says it all. I have developed the database locally, and
added a nicley formatted diagram to it, and would like to spare the
possibility to remake it once again on another database that has exactly the
same structure. So, there must be some way to copy the diagram from here to
there. I'd appreciate if someone could hint me how that could be possible to
achieve.
Thank you,
-- PavilsThe following article explains how to do it:
HOW TO: Move a Database Diagram
http://support.microsoft.com/?id=320125
-Sue
On Tue, 2 Mar 2004 16:31:13 +0200, "Pavils Jurjans"
<pavils@.mailbox.riga.lv> wrote:
>Hallo,
>The subj actually says it all. I have developed the database locally, and
>added a nicley formatted diagram to it, and would like to spare the
>possibility to remake it once again on another database that has exactly the
>same structure. So, there must be some way to copy the diagram from here to
>there. I'd appreciate if someone could hint me how that could be possible to
>achieve.
>Thank you,
>-- Pavils
>|||Thanks, that works well. Luckily, I have only one diag to copy and the
destination database does not contain any diagrams. There could be
complications using this copy *.* approach on some finer cases.
-- Pavils
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:s279401gpnvhr8892a3s1gq7rsqoi4rnpl@.4ax.com...
> The following article explains how to do it:
> HOW TO: Move a Database Diagram
> http://support.microsoft.com/?id=320125
> -Sue
> On Tue, 2 Mar 2004 16:31:13 +0200, "Pavils Jurjans"
> <pavils@.mailbox.riga.lv> wrote:
> >Hallo,
> >
> >The subj actually says it all. I have developed the database locally, and
> >added a nicley formatted diagram to it, and would like to spare the
> >possibility to remake it once again on another database that has exactly
the
> >same structure. So, there must be some way to copy the diagram from here
to
> >there. I'd appreciate if someone could hint me how that could be possible
to
> >achieve.
> >
> >Thank you,
> >
> >-- Pavils
> >
>

Saturday, February 25, 2012

Copy a diagram from a db to another db in sql server 2005

Hello,
is there a way in SQL Server 2005 to copy a diagram from a database to
another one that has exactly the
same structure?
Thank you in advance,
Laura
You need to create the support tables for diagrams in the
destination database first - you can just click on the
database diagrams node in the destination database and
select Yes when the message box comes up asking if you want
to create the objects to use database diagramming.
Then import the dbo.sysdiagrams table from the source
database.
-Sue
On Tue, 31 Jul 2007 07:14:01 -0700, Isotta
<laura.lega@.gmail.com> wrote:

>Hello,
>is there a way in SQL Server 2005 to copy a diagram from a database to
>another one that has exactly the
>same structure?
>Thank you in advance,
>Laura

Copy a diagram from a db to another db in sql server 2005

Hello,
is there a way in SQL Server 2005 to copy a diagram from a database to
another one that has exactly the
same structure?
Thank you in advance,
LauraYou need to create the support tables for diagrams in the
destination database first - you can just click on the
database diagrams node in the destination database and
select Yes when the message box comes up asking if you want
to create the objects to use database diagramming.
Then import the dbo.sysdiagrams table from the source
database.
-Sue
On Tue, 31 Jul 2007 07:14:01 -0700, Isotta
<laura.lega@.gmail.com> wrote:

>Hello,
>is there a way in SQL Server 2005 to copy a diagram from a database to
>another one that has exactly the
>same structure?
>Thank you in advance,
>Laura

Copy a diagram from a db to another db in sql server 2005

Hello,
is there a way in SQL Server 2005 to copy a diagram from a database to
another one that has exactly the
same structure?
Thank you in advance,
LauraYou need to create the support tables for diagrams in the
destination database first - you can just click on the
database diagrams node in the destination database and
select Yes when the message box comes up asking if you want
to create the objects to use database diagramming.
Then import the dbo.sysdiagrams table from the source
database.
-Sue
On Tue, 31 Jul 2007 07:14:01 -0700, Isotta
<laura.lega@.gmail.com> wrote:
>Hello,
>is there a way in SQL Server 2005 to copy a diagram from a database to
>another one that has exactly the
>same structure?
>Thank you in advance,
>Laura

Copy a big Diagram in SQL Server

Hi group,
Does anybody know a way to copy a rather big diagram in SQLServer to the
clipboard?
I need the diagram in my documentation (HTML) and would like to grab it as 1
picture and use it in the documentation.
Making a screenshot doesn't help either, because it is impossible to make
the window containing the diagram bigger than the screen (without
scrollbars) for some reason in SQL Server 7.
I can make 10 screenshots and make 1 picture of them in a paintprogram, but
that is rather tedious work. (I did it that way in previous projects)
So I am curious if somebody has a more handy solution for me.
(Not being lazy, just curious)
Regards and thanks for your time,
Erwin Moller
AFAIK there is no C&P functionality for EM, best thing would be to use
a database modeller with reverse engineering like VISIO or Ervin.
HTH, jens Suessmeyer.

Copy a big Diagram in SQL Server

Hi group,
Does anybody know a way to copy a rather big diagram in SQLServer to the
clipboard?
I need the diagram in my documentation (HTML) and would like to grab it as 1
picture and use it in the documentation.
Making a screenshot doesn't help either, because it is impossible to make
the window containing the diagram bigger than the screen (without
scrollbars) for some reason in SQL Server 7.
I can make 10 screenshots and make 1 picture of them in a paintprogram, but
that is rather tedious work. (I did it that way in previous projects)
So I am curious if somebody has a more handy solution for me.
(Not being lazy, just curious)
Regards and thanks for your time,
Erwin MollerAFAIK there is no C&P functionality for EM, best thing would be to use
a database modeller with reverse engineering like visio or Ervin.
HTH, jens Suessmeyer.