hi all,
i can import my database diagram from
sql server using the data>reverse engineer feature
the question is
how can i send it back?
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787correction that Visio not vision
--
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"Jose G. de Jesus Jr MCP, MCDBA" wrote:
> hi all,
> i can import my database diagram from
> sql server using the data>reverse engineer feature
> the question is
> how can i send it back?
> --
> thanks,
> --
> Jose de Jesus Jr. Mcp,Mcdba
> Data Architect
> Sykes Asia (Manila philippines)
> MCP #2324787|||Hello,
As far as I remember, you can do that only with Visio for Enterprise
Architects 2003 Edition
Mary
"Jose G. de Jesus Jr MCP, MCDBA" <Email me> wrote in message
news:AA9FF22E-EE50-4AF9-BDA3-006AE243307D@.microsoft.com...
> correction that Visio not vision
> --
> thanks,
> --
> Jose de Jesus Jr. Mcp,Mcdba
> Data Architect
> Sykes Asia (Manila philippines)
> MCP #2324787
>
> "Jose G. de Jesus Jr MCP, MCDBA" wrote:
>|||Hi
For SQL 2000 diagrams and Visio diagrams are different things, you can not
export it back into SQL Server. If you want to update your database with
schema changes in the model then use the Update option on the database menu.
John
"Jose G. de Jesus Jr MCP, MCDBA" wrote:
> correction that Visio not vision
> --
> thanks,
> --
> Jose de Jesus Jr. Mcp,Mcdba
> Data Architect
> Sykes Asia (Manila philippines)
> MCP #2324787
>
> "Jose G. de Jesus Jr MCP, MCDBA" wrote:
>
Showing posts with label diagram. Show all posts
Showing posts with label diagram. Show all posts
Tuesday, March 27, 2012
Sunday, March 25, 2012
Exporting Diagram
Hi,
How can i export diagram from one database to another database ?Hi
Try:
http://support.microsoft.com/defaul...kb;en-us;320125
John
"DMP" wrote:
> Hi,
> How can i export diagram from one database to another database ?
>
>|||I wrote a System Stored Proc for that... If you put this in Master Dataabse,
it will be available from any Database...
Create Procedure dbo.sp_MoveDiagram
@.DiagGramName VarChar(255),
@.SourceDB VarChar(255),
@.DestDB VarChar(255)
As
Set NoCount On
Declare @.NL nChar(2) Set @.NL = Char(13) + Char(10)
Declare @.Sql nVarChar(3000)
Set @.Sql = 'Set Identity_Insert ' +
@.DestDB + '..dtproperties On ' + @.NL
-- ---
Set @.Sql = @.Sql + ' Insert ' + @.DestDB +
'..dtproperties(id,objectid,property,' +
'value,lvalue,uvalue,version)' +
'Select id,objectid,property,value,' +
'lvalue,uvalue,version From ' +
@.SourceDB + '..dtproperties Where ' +
@.SourceDB + '..dtproperties.objectID = ' +
'(Select ObjectID From ' + @.SourceDB +
'..dtproperties Where Property = ''DtgSchemaNAME''' +
'And Value = ''' + @.DiagGramName + ''')' + @.NL
-- ---
Set @.Sql = @.Sql + 'Set Identity_Insert ' +
@.DestDB + '..dtproperties Off'
--Select @.Sql Sql
Exec sp_ExecuteSql @.Sql
-- ---
Return(0)
-- ----
"DMP" wrote:
> Hi,
> How can i export diagram from one database to another database ?
>
>|||Thanks for reply,
can i move a stored procedure through user SP ?
"CBretana" <cbretana@.areteIndNOSPAM.com> wrote in message
news:7B8E66E2-4B32-4B51-BD34-66009A36DA15@.microsoft.com...
>I wrote a System Stored Proc for that... If you put this in Master
>Dataabse,
> it will be available from any Database...
> Create Procedure dbo.sp_MoveDiagram
> @.DiagGramName VarChar(255),
> @.SourceDB VarChar(255),
> @.DestDB VarChar(255)
> As
> Set NoCount On
> Declare @.NL nChar(2) Set @.NL = Char(13) + Char(10)
> Declare @.Sql nVarChar(3000)
>
> Set @.Sql = 'Set Identity_Insert ' +
> @.DestDB + '..dtproperties On ' + @.NL
> -- ---
> Set @.Sql = @.Sql + ' Insert ' + @.DestDB +
> '..dtproperties(id,objectid,property,' +
> 'value,lvalue,uvalue,version)' +
> 'Select id,objectid,property,value,' +
> 'lvalue,uvalue,version From ' +
> @.SourceDB + '..dtproperties Where ' +
> @.SourceDB + '..dtproperties.objectID = ' +
> '(Select ObjectID From ' + @.SourceDB +
> '..dtproperties Where Property = ''DtgSchemaNAME''' +
> 'And Value = ''' + @.DiagGramName + ''')' + @.NL
> -- ---
> Set @.Sql = @.Sql + 'Set Identity_Insert ' +
> @.DestDB + '..dtproperties Off'
> --Select @.Sql Sql
> Exec sp_ExecuteSql @.Sql
> -- ---
> Return(0)
> -- ----
>
> "DMP" wrote:
>
How can i export diagram from one database to another database ?Hi
Try:
http://support.microsoft.com/defaul...kb;en-us;320125
John
"DMP" wrote:
> Hi,
> How can i export diagram from one database to another database ?
>
>|||I wrote a System Stored Proc for that... If you put this in Master Dataabse,
it will be available from any Database...
Create Procedure dbo.sp_MoveDiagram
@.DiagGramName VarChar(255),
@.SourceDB VarChar(255),
@.DestDB VarChar(255)
As
Set NoCount On
Declare @.NL nChar(2) Set @.NL = Char(13) + Char(10)
Declare @.Sql nVarChar(3000)
Set @.Sql = 'Set Identity_Insert ' +
@.DestDB + '..dtproperties On ' + @.NL
-- ---
Set @.Sql = @.Sql + ' Insert ' + @.DestDB +
'..dtproperties(id,objectid,property,' +
'value,lvalue,uvalue,version)' +
'Select id,objectid,property,value,' +
'lvalue,uvalue,version From ' +
@.SourceDB + '..dtproperties Where ' +
@.SourceDB + '..dtproperties.objectID = ' +
'(Select ObjectID From ' + @.SourceDB +
'..dtproperties Where Property = ''DtgSchemaNAME''' +
'And Value = ''' + @.DiagGramName + ''')' + @.NL
-- ---
Set @.Sql = @.Sql + 'Set Identity_Insert ' +
@.DestDB + '..dtproperties Off'
--Select @.Sql Sql
Exec sp_ExecuteSql @.Sql
-- ---
Return(0)
-- ----
"DMP" wrote:
> Hi,
> How can i export diagram from one database to another database ?
>
>|||Thanks for reply,
can i move a stored procedure through user SP ?
"CBretana" <cbretana@.areteIndNOSPAM.com> wrote in message
news:7B8E66E2-4B32-4B51-BD34-66009A36DA15@.microsoft.com...
>I wrote a System Stored Proc for that... If you put this in Master
>Dataabse,
> it will be available from any Database...
> Create Procedure dbo.sp_MoveDiagram
> @.DiagGramName VarChar(255),
> @.SourceDB VarChar(255),
> @.DestDB VarChar(255)
> As
> Set NoCount On
> Declare @.NL nChar(2) Set @.NL = Char(13) + Char(10)
> Declare @.Sql nVarChar(3000)
>
> Set @.Sql = 'Set Identity_Insert ' +
> @.DestDB + '..dtproperties On ' + @.NL
> -- ---
> Set @.Sql = @.Sql + ' Insert ' + @.DestDB +
> '..dtproperties(id,objectid,property,' +
> 'value,lvalue,uvalue,version)' +
> 'Select id,objectid,property,value,' +
> 'lvalue,uvalue,version From ' +
> @.SourceDB + '..dtproperties Where ' +
> @.SourceDB + '..dtproperties.objectID = ' +
> '(Select ObjectID From ' + @.SourceDB +
> '..dtproperties Where Property = ''DtgSchemaNAME''' +
> 'And Value = ''' + @.DiagGramName + ''')' + @.NL
> -- ---
> Set @.Sql = @.Sql + 'Set Identity_Insert ' +
> @.DestDB + '..dtproperties Off'
> --Select @.Sql Sql
> Exec sp_ExecuteSql @.Sql
> -- ---
> Return(0)
> -- ----
>
> "DMP" wrote:
>
Exporting diagram
When using 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.
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,
Nielsdtproperties doesnt show up in the query builder. just write it by hand "select * from dtproperties"
also, if you dont create the destination file/object (i.e. flat text file) prior to running this it will complain about an object not being found. for instance if you name your destination file dtproperties.txt in the exporter but it doesnt exist it will complain -- at least it did for me.
Exporting database diagram.
SQL2K
Is there a way of exporting a database diagram from sql server?check this link :
http://support.microsoft.com/defaul...b;en-us;Q320125
regards,
harsh.
<KJGNews@.hotmail.com> wrote in message
news:OIyW9PZ5DHA.2556@.TK2MSFTNGP09.phx.gbl...
Is there any way of exporting a diagram into something like Visio,
or even a .bmp/.jpg format so it can be held externally.
"harsh" <harshalmistry@.hotmail.com> wrote in message
news:ONoiXUZ5DHA.2740@.TK2MSFTNGP09.phx.gbl...
Thank you for using the newsgroup and it is my pleasure to help you with
your issue.
Based on my knowledge, there is no method to export the diagrams to export
the diagram as a viso file or pictures such as .bmp and .gif ( print screen
may not be the case).
If you still have questions ,please fee free to post here and I am ready to
help!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||The best I've found, is a feature in visio to reverse engineer a database.
So long as the keys and relationships are set up properly this will reflect
in the visio diagram, which is nice....
"Baisong Wei[MSFT]" <v-baiwei@.online.microsoft.com> wrote in message
news:aSo9ywv5DHA.568@.cpmsftngxa07.phx.gbl...
screen
to
Thank you for using the newsgroup!
I am glad that you have found a method to get the diagram. My answer just
mean from the SQL Server side, there is no method for you to EXPORT the
diagrams, the VISO2000 could importing the diagram of many databases
including SQL Server and it is really an exciting feather. For VISO2000,
there are many other exiting feathers for your development and you could
get more information for our related newsgroup:
http://support.microsoft.com/newsgr...&NewsGroup=micr
osoft.public.visio.developer.diagrams
or
news:microsoft.public.visio.developer.diagrams
Our engineer there will provide you more information in that newsgroup!
Thanks again.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Visio is some what popular because of its availability. There are many
applications but direct export of the Diagram from SQL server is not
possible. In the past I have used screen shot and created a
presentation and that was possible because it was a small database.
Erwin/AllFusion is most popular and that is what I use because of its
functionality beyond being pretty like Visio, but it is expensive. If
you have access to VS or Access you should be also able to create
Diagram from it.
Is there a way of exporting a database diagram from sql server?check this link :
http://support.microsoft.com/defaul...b;en-us;Q320125
regards,
harsh.
<KJGNews@.hotmail.com> wrote in message
news:OIyW9PZ5DHA.2556@.TK2MSFTNGP09.phx.gbl...
quote:|||Sorry, should rephrase that,
> SQL2K
> Is there a way of exporting a database diagram from sql server?
>
Is there any way of exporting a diagram into something like Visio,
or even a .bmp/.jpg format so it can be held externally.
"harsh" <harshalmistry@.hotmail.com> wrote in message
news:ONoiXUZ5DHA.2740@.TK2MSFTNGP09.phx.gbl...
quote:|||Hi
> check this link :
> http://support.microsoft.com/defaul...b;en-us;Q320125
> regards,
> harsh.
> <KJGNews@.hotmail.com> wrote in message
> news:OIyW9PZ5DHA.2556@.TK2MSFTNGP09.phx.gbl...
>
Thank you for using the newsgroup and it is my pleasure to help you with
your issue.
Based on my knowledge, there is no method to export the diagrams to export
the diagram as a viso file or pictures such as .bmp and .gif ( print screen
may not be the case).
If you still have questions ,please fee free to post here and I am ready to
help!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||The best I've found, is a feature in visio to reverse engineer a database.
So long as the keys and relationships are set up properly this will reflect
in the visio diagram, which is nice....
"Baisong Wei[MSFT]" <v-baiwei@.online.microsoft.com> wrote in message
news:aSo9ywv5DHA.568@.cpmsftngxa07.phx.gbl...
quote:
> Hi
> Thank you for using the newsgroup and it is my pleasure to help you with
> your issue.
> Based on my knowledge, there is no method to export the diagrams to export
> the diagram as a viso file or pictures such as .bmp and .gif ( print
screen
quote:
> may not be the case).
> If you still have questions ,please fee free to post here and I am ready
to
quote:|||Hi Kevin
> help!
>
> Best regards
> Baisong Wei
> Microsoft Online Support
> ----
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only. Thanks.
>
Thank you for using the newsgroup!
I am glad that you have found a method to get the diagram. My answer just
mean from the SQL Server side, there is no method for you to EXPORT the
diagrams, the VISO2000 could importing the diagram of many databases
including SQL Server and it is really an exciting feather. For VISO2000,
there are many other exiting feathers for your development and you could
get more information for our related newsgroup:
http://support.microsoft.com/newsgr...&NewsGroup=micr
osoft.public.visio.developer.diagrams
or
news:microsoft.public.visio.developer.diagrams
Our engineer there will provide you more information in that newsgroup!
Thanks again.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Visio is some what popular because of its availability. There are many
applications but direct export of the Diagram from SQL server is not
possible. In the past I have used screen shot and created a
presentation and that was possible because it was a small database.
Erwin/AllFusion is most popular and that is what I use because of its
functionality beyond being pretty like Visio, but it is expensive. If
you have access to VS or Access you should be also able to create
Diagram from it.
Exporting database diagram.
SQL2K
Is there a way of exporting a database diagram from sql server?check this link :
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125
regards,
harsh.
<KJGNews@.hotmail.com> wrote in message
news:OIyW9PZ5DHA.2556@.TK2MSFTNGP09.phx.gbl...
> SQL2K
> Is there a way of exporting a database diagram from sql server?
>|||Sorry, should rephrase that,
Is there any way of exporting a diagram into something like Visio,
or even a .bmp/.jpg format so it can be held externally.
"harsh" <harshalmistry@.hotmail.com> wrote in message
news:ONoiXUZ5DHA.2740@.TK2MSFTNGP09.phx.gbl...
> check this link :
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125
> regards,
> harsh.
> <KJGNews@.hotmail.com> wrote in message
> news:OIyW9PZ5DHA.2556@.TK2MSFTNGP09.phx.gbl...
> > SQL2K
> >
> > Is there a way of exporting a database diagram from sql server?
> >
> >
>|||Hi
Thank you for using the newsgroup and it is my pleasure to help you with
your issue.
Based on my knowledge, there is no method to export the diagrams to export
the diagram as a viso file or pictures such as .bmp and .gif ( print screen
may not be the case).
If you still have questions ,please fee free to post here and I am ready to
help!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||The best I've found, is a feature in visio to reverse engineer a database.
So long as the keys and relationships are set up properly this will reflect
in the visio diagram, which is nice....
"Baisong Wei[MSFT]" <v-baiwei@.online.microsoft.com> wrote in message
news:aSo9ywv5DHA.568@.cpmsftngxa07.phx.gbl...
> Hi
> Thank you for using the newsgroup and it is my pleasure to help you with
> your issue.
> Based on my knowledge, there is no method to export the diagrams to export
> the diagram as a viso file or pictures such as .bmp and .gif ( print
screen
> may not be the case).
> If you still have questions ,please fee free to post here and I am ready
to
> help!
>
> Best regards
> Baisong Wei
> Microsoft Online Support
> ----
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only. Thanks.
>|||Hi Kevin
Thank you for using the newsgroup!
I am glad that you have found a method to get the diagram. My answer just
mean from the SQL Server side, there is no method for you to EXPORT the
diagrams, the VISO2000 could importing the diagram of many databases
including SQL Server and it is really an exciting feather. For VISO2000,
there are many other exiting feathers for your development and you could
get more information for our related newsgroup:
http://support.microsoft.com/newsgroups/default.aspx?ICP=GSS3&NewsGroup=micr
osoft.public.visio.developer.diagrams
or
news:microsoft.public.visio.developer.diagrams
Our engineer there will provide you more information in that newsgroup!
Thanks again.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Visio is some what popular because of its availability. There are many
applications but direct export of the Diagram from SQL server is not
possible. In the past I have used screen shot and created a
presentation and that was possible because it was a small database.
Erwin/AllFusion is most popular and that is what I use because of its
functionality beyond being pretty like Visio, but it is expensive. If
you have access to VS or Access you should be also able to create
Diagram from it.
Is there a way of exporting a database diagram from sql server?check this link :
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125
regards,
harsh.
<KJGNews@.hotmail.com> wrote in message
news:OIyW9PZ5DHA.2556@.TK2MSFTNGP09.phx.gbl...
> SQL2K
> Is there a way of exporting a database diagram from sql server?
>|||Sorry, should rephrase that,
Is there any way of exporting a diagram into something like Visio,
or even a .bmp/.jpg format so it can be held externally.
"harsh" <harshalmistry@.hotmail.com> wrote in message
news:ONoiXUZ5DHA.2740@.TK2MSFTNGP09.phx.gbl...
> check this link :
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125
> regards,
> harsh.
> <KJGNews@.hotmail.com> wrote in message
> news:OIyW9PZ5DHA.2556@.TK2MSFTNGP09.phx.gbl...
> > SQL2K
> >
> > Is there a way of exporting a database diagram from sql server?
> >
> >
>|||Hi
Thank you for using the newsgroup and it is my pleasure to help you with
your issue.
Based on my knowledge, there is no method to export the diagrams to export
the diagram as a viso file or pictures such as .bmp and .gif ( print screen
may not be the case).
If you still have questions ,please fee free to post here and I am ready to
help!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||The best I've found, is a feature in visio to reverse engineer a database.
So long as the keys and relationships are set up properly this will reflect
in the visio diagram, which is nice....
"Baisong Wei[MSFT]" <v-baiwei@.online.microsoft.com> wrote in message
news:aSo9ywv5DHA.568@.cpmsftngxa07.phx.gbl...
> Hi
> Thank you for using the newsgroup and it is my pleasure to help you with
> your issue.
> Based on my knowledge, there is no method to export the diagrams to export
> the diagram as a viso file or pictures such as .bmp and .gif ( print
screen
> may not be the case).
> If you still have questions ,please fee free to post here and I am ready
to
> help!
>
> Best regards
> Baisong Wei
> Microsoft Online Support
> ----
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only. Thanks.
>|||Hi Kevin
Thank you for using the newsgroup!
I am glad that you have found a method to get the diagram. My answer just
mean from the SQL Server side, there is no method for you to EXPORT the
diagrams, the VISO2000 could importing the diagram of many databases
including SQL Server and it is really an exciting feather. For VISO2000,
there are many other exiting feathers for your development and you could
get more information for our related newsgroup:
http://support.microsoft.com/newsgroups/default.aspx?ICP=GSS3&NewsGroup=micr
osoft.public.visio.developer.diagrams
or
news:microsoft.public.visio.developer.diagrams
Our engineer there will provide you more information in that newsgroup!
Thanks again.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Visio is some what popular because of its availability. There are many
applications but direct export of the Diagram from SQL server is not
possible. In the past I have used screen shot and created a
presentation and that was possible because it was a small database.
Erwin/AllFusion is most popular and that is what I use because of its
functionality beyond being pretty like Visio, but it is expensive. If
you have access to VS or Access you should be also able to create
Diagram from it.
Thursday, March 22, 2012
Exporting an Image of a Diagram
Is it possible to export an image of a diagram?
I would like to export some of the diagrams I have in my database for both
documenting purposes and to post online when I get stuck.
At the moment I am doing screen shots of them, but some are bigger than I
can display on one screen.
But there's a way you can do that indirectly - using some graphical tool
with reverse engineering ability. I recommend MS Visio for Enterprise
Architects in this case.
mac
"Keith" <@..> wrote in message news:ecxmkRWHEHA.3556@.TK2MSFTNGP10.phx.gbl...
> Is it possible to export an image of a diagram?
> I would like to export some of the diagrams I have in my database for both
> documenting purposes and to post online when I get stuck.
> At the moment I am doing screen shots of them, but some are bigger than I
> can display on one screen.
>
|||I have Visio 2002 Pro installed - will that do it or do I need to uninstall
and install the EA version that came with my Visual Studio?
"mac" <martin_kotuc@.yahoo.com> wrote in message
news:OJYyeDXHEHA.3556@.TK2MSFTNGP10.phx.gbl...
> But there's a way you can do that indirectly - using some graphical tool
> with reverse engineering ability. I recommend MS Visio for Enterprise
> Architects in this case.
> mac
>
> "Keith" <@..> wrote in message
news:ecxmkRWHEHA.3556@.TK2MSFTNGP10.phx.gbl...
both
I
>
sql
I would like to export some of the diagrams I have in my database for both
documenting purposes and to post online when I get stuck.
At the moment I am doing screen shots of them, but some are bigger than I
can display on one screen.
But there's a way you can do that indirectly - using some graphical tool
with reverse engineering ability. I recommend MS Visio for Enterprise
Architects in this case.
mac
"Keith" <@..> wrote in message news:ecxmkRWHEHA.3556@.TK2MSFTNGP10.phx.gbl...
> Is it possible to export an image of a diagram?
> I would like to export some of the diagrams I have in my database for both
> documenting purposes and to post online when I get stuck.
> At the moment I am doing screen shots of them, but some are bigger than I
> can display on one screen.
>
|||I have Visio 2002 Pro installed - will that do it or do I need to uninstall
and install the EA version that came with my Visual Studio?
"mac" <martin_kotuc@.yahoo.com> wrote in message
news:OJYyeDXHEHA.3556@.TK2MSFTNGP10.phx.gbl...
> But there's a way you can do that indirectly - using some graphical tool
> with reverse engineering ability. I recommend MS Visio for Enterprise
> Architects in this case.
> mac
>
> "Keith" <@..> wrote in message
news:ecxmkRWHEHA.3556@.TK2MSFTNGP10.phx.gbl...
both
I
>
sql
Exporting an Image of a Diagram
Is it possible to export an image of a diagram?
I would like to export some of the diagrams I have in my database for both
documenting purposes and to post online when I get stuck.
At the moment I am doing screen shots of them, but some are bigger than I
can display on one screen.You have asked for the very thing every DBA has asked for
since the diagram facility was put in, and the answer is
still no.
Sorry
J
>--Original Message--
>Is it possible to export an image of a diagram?
>I would like to export some of the diagrams I have in my
database for both
>documenting purposes and to post online when I get stuck.
>At the moment I am doing screen shots of them, but some
are bigger than I
>can display on one screen.
>
>.
>|||But there's a way you can do that indirectly - using some graphical tool
with reverse engineering ability. I recommend MS Visio for Enterprise
Architects in this case.
mac
"Keith" <@..> wrote in message news:ecxmkRWHEHA.3556@.TK2MSFTNGP10.phx.gbl...
> Is it possible to export an image of a diagram?
> I would like to export some of the diagrams I have in my database for both
> documenting purposes and to post online when I get stuck.
> At the moment I am doing screen shots of them, but some are bigger than I
> can display on one screen.
>|||I have Visio 2002 Pro installed - will that do it or do I need to uninstall
and install the EA version that came with my Visual Studio?
"mac" <martin_kotuc@.yahoo.com> wrote in message
news:OJYyeDXHEHA.3556@.TK2MSFTNGP10.phx.gbl...
> But there's a way you can do that indirectly - using some graphical tool
> with reverse engineering ability. I recommend MS Visio for Enterprise
> Architects in this case.
> mac
>
> "Keith" <@..> wrote in message
news:ecxmkRWHEHA.3556@.TK2MSFTNGP10.phx.gbl...
> > Is it possible to export an image of a diagram?
> >
> > I would like to export some of the diagrams I have in my database for
both
> > documenting purposes and to post online when I get stuck.
> >
> > At the moment I am doing screen shots of them, but some are bigger than
I
> > can display on one screen.
> >
> >
>
I would like to export some of the diagrams I have in my database for both
documenting purposes and to post online when I get stuck.
At the moment I am doing screen shots of them, but some are bigger than I
can display on one screen.You have asked for the very thing every DBA has asked for
since the diagram facility was put in, and the answer is
still no.
Sorry
J
>--Original Message--
>Is it possible to export an image of a diagram?
>I would like to export some of the diagrams I have in my
database for both
>documenting purposes and to post online when I get stuck.
>At the moment I am doing screen shots of them, but some
are bigger than I
>can display on one screen.
>
>.
>|||But there's a way you can do that indirectly - using some graphical tool
with reverse engineering ability. I recommend MS Visio for Enterprise
Architects in this case.
mac
"Keith" <@..> wrote in message news:ecxmkRWHEHA.3556@.TK2MSFTNGP10.phx.gbl...
> Is it possible to export an image of a diagram?
> I would like to export some of the diagrams I have in my database for both
> documenting purposes and to post online when I get stuck.
> At the moment I am doing screen shots of them, but some are bigger than I
> can display on one screen.
>|||I have Visio 2002 Pro installed - will that do it or do I need to uninstall
and install the EA version that came with my Visual Studio?
"mac" <martin_kotuc@.yahoo.com> wrote in message
news:OJYyeDXHEHA.3556@.TK2MSFTNGP10.phx.gbl...
> But there's a way you can do that indirectly - using some graphical tool
> with reverse engineering ability. I recommend MS Visio for Enterprise
> Architects in this case.
> mac
>
> "Keith" <@..> wrote in message
news:ecxmkRWHEHA.3556@.TK2MSFTNGP10.phx.gbl...
> > Is it possible to export an image of a diagram?
> >
> > I would like to export some of the diagrams I have in my database for
both
> > documenting purposes and to post online when I get stuck.
> >
> > At the moment I am doing screen shots of them, but some are bigger than
I
> > can display on one screen.
> >
> >
>
Exporting an Image of a Diagram
Is it possible to export an image of a diagram?
I would like to export some of the diagrams I have in my database for both
documenting purposes and to post online when I get stuck.
At the moment I am doing screen shots of them, but some are bigger than I
can display on one screen.But there's a way you can do that indirectly - using some graphical tool
with reverse engineering ability. I recommend MS visio for Enterprise
Architects in this case.
mac
"Keith" <@..> wrote in message news:ecxmkRWHEHA.3556@.TK2MSFTNGP10.phx.gbl...
> Is it possible to export an image of a diagram?
> I would like to export some of the diagrams I have in my database for both
> documenting purposes and to post online when I get stuck.
> At the moment I am doing screen shots of them, but some are bigger than I
> can display on one screen.
>|||I have visio 2002 Pro installed - will that do it or do I need to uninstall
and install the EA version that came with my Visual Studio?
"mac" <martin_kotuc@.yahoo.com> wrote in message
news:OJYyeDXHEHA.3556@.TK2MSFTNGP10.phx.gbl...
> But there's a way you can do that indirectly - using some graphical tool
> with reverse engineering ability. I recommend MS visio for Enterprise
> Architects in this case.
> mac
>
> "Keith" <@..> wrote in message
news:ecxmkRWHEHA.3556@.TK2MSFTNGP10.phx.gbl...
both
I
>
I would like to export some of the diagrams I have in my database for both
documenting purposes and to post online when I get stuck.
At the moment I am doing screen shots of them, but some are bigger than I
can display on one screen.But there's a way you can do that indirectly - using some graphical tool
with reverse engineering ability. I recommend MS visio for Enterprise
Architects in this case.
mac
"Keith" <@..> wrote in message news:ecxmkRWHEHA.3556@.TK2MSFTNGP10.phx.gbl...
> Is it possible to export an image of a diagram?
> I would like to export some of the diagrams I have in my database for both
> documenting purposes and to post online when I get stuck.
> At the moment I am doing screen shots of them, but some are bigger than I
> can display on one screen.
>|||I have visio 2002 Pro installed - will that do it or do I need to uninstall
and install the EA version that came with my Visual Studio?
"mac" <martin_kotuc@.yahoo.com> wrote in message
news:OJYyeDXHEHA.3556@.TK2MSFTNGP10.phx.gbl...
> But there's a way you can do that indirectly - using some graphical tool
> with reverse engineering ability. I recommend MS visio for Enterprise
> Architects in this case.
> mac
>
> "Keith" <@..> wrote in message
news:ecxmkRWHEHA.3556@.TK2MSFTNGP10.phx.gbl...
both
I
>
Friday, February 17, 2012
Export SQL server Diagram.
Can I export SQL server diagram into VISIO?
I found an article that saves dtproperties table to export diagram. I don't
know if you can import the DTS package into visio or not.No, you can't do that... ( MS is usually so good at integration of its
products, but this is one place there is no integration.)
Probably the best thing to do is simply reverse engineer the db using
Visio,,, You'll get what you need quickly.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"strout" <strout@.discussions.microsoft.com> wrote in message
news:C434DCA6-68BF-4A28-9DC4-C6D1C005B3C0@.microsoft.com...
> Can I export SQL server diagram into VISIO?
> I found an article that saves dtproperties table to export diagram. I
> don't
> know if you can import the DTS package into visio or not.
>
I found an article that saves dtproperties table to export diagram. I don't
know if you can import the DTS package into visio or not.No, you can't do that... ( MS is usually so good at integration of its
products, but this is one place there is no integration.)
Probably the best thing to do is simply reverse engineer the db using
Visio,,, You'll get what you need quickly.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"strout" <strout@.discussions.microsoft.com> wrote in message
news:C434DCA6-68BF-4A28-9DC4-C6D1C005B3C0@.microsoft.com...
> Can I export SQL server diagram into VISIO?
> I found an article that saves dtproperties table to export diagram. I
> don't
> know if you can import the DTS package into visio or not.
>
Export SQL server Diagram.
Can I export SQL server diagram into VISIO?
I found an article that saves dtproperties table to export diagram. I don't
know if you can import the DTS package into VISIO or not.No, you can't do that... ( MS is usually so good at integration of its
products, but this is one place there is no integration.)
Probably the best thing to do is simply reverse engineer the db using
Visio,,, You'll get what you need quickly.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"strout" <strout@.discussions.microsoft.com> wrote in message
news:C434DCA6-68BF-4A28-9DC4-C6D1C005B3C0@.microsoft.com...
> Can I export SQL server diagram into VISIO?
> I found an article that saves dtproperties table to export diagram. I
> don't
> know if you can import the DTS package into VISIO or not.
>
I found an article that saves dtproperties table to export diagram. I don't
know if you can import the DTS package into VISIO or not.No, you can't do that... ( MS is usually so good at integration of its
products, but this is one place there is no integration.)
Probably the best thing to do is simply reverse engineer the db using
Visio,,, You'll get what you need quickly.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"strout" <strout@.discussions.microsoft.com> wrote in message
news:C434DCA6-68BF-4A28-9DC4-C6D1C005B3C0@.microsoft.com...
> Can I export SQL server diagram into VISIO?
> I found an article that saves dtproperties table to export diagram. I
> don't
> know if you can import the DTS package into VISIO or not.
>
Export SQL server Diagram.
Can I export SQL server diagram into VISIO?
I found an article that saves dtproperties table to export diagram. I don't
know if you can import the DTS package into VISIO or not.
No, you can't do that... ( MS is usually so good at integration of its
products, but this is one place there is no integration.)
Probably the best thing to do is simply reverse engineer the db using
Visio,,, You'll get what you need quickly.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"strout" <strout@.discussions.microsoft.com> wrote in message
news:C434DCA6-68BF-4A28-9DC4-C6D1C005B3C0@.microsoft.com...
> Can I export SQL server diagram into VISIO?
> I found an article that saves dtproperties table to export diagram. I
> don't
> know if you can import the DTS package into VISIO or not.
>
I found an article that saves dtproperties table to export diagram. I don't
know if you can import the DTS package into VISIO or not.
No, you can't do that... ( MS is usually so good at integration of its
products, but this is one place there is no integration.)
Probably the best thing to do is simply reverse engineer the db using
Visio,,, You'll get what you need quickly.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"strout" <strout@.discussions.microsoft.com> wrote in message
news:C434DCA6-68BF-4A28-9DC4-C6D1C005B3C0@.microsoft.com...
> Can I export SQL server diagram into VISIO?
> I found an article that saves dtproperties table to export diagram. I
> don't
> know if you can import the DTS package into VISIO or not.
>
Subscribe to:
Posts (Atom)