|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
copy database diagram to Visio from the Diagram window (sqlsvr2000I have seen database diagrams of a sql server(2000) database in Visio(2003).
I need to create a similar diagram in visio with my DB. Anybody know how to do this? I opened up Visio, selected New/Databases/Diagram... then what? Thanks, Rich Rich,
If you have Visio 2003 for Enterprise Architects you can "forward engineer" your Visio diagram into the necessary CREATE statements to make a database based on your model. Then, inside SQL Server you can create a diagram. But there is no diagram to diagram move feature. If you are using a more recent version of Visio this post http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=969126&SiteID=1 comments as follows: Visio 2007 Standard/Professional itself does not support forward engineering the the SQL server. Only the Visio for Enterprise (VEA) which shipped with Visual Studio Team Architect support the forward code gen functionality. I believe that the above is true for Visio 2005 as well. RLF Show quote "Rich" <R***@discussions.microsoft.com> wrote in message news:C56FC3C3-8A7E-46DC-B57B-ECD6583365BF@microsoft.com... >I have seen database diagrams of a sql server(2000) database in >Visio(2003). > I need to create a similar diagram in visio with my DB. Anybody know how > to > do this? I opened up Visio, selected New/Databases/Diagram... then what? > > Thanks, > Rich Thanks. I have visio 2003. I did not see an option for Forward Engineering
(after selecting Database). But I did see an option for Reverse Engineering. I am guessing that may be the same thing. When I select that option from the Database menu, I set up a connection to my server - click OK, and it imports a list of all the tables in my DB. Then I drag the tables onto the canvas (or whatever they call the drawing form). I will have to play around with it a bit. One problem I am having is that I can't shrink the table field list for tables with lots of fields. And I am having a problem stretching the canvas to fit all my tables. I know it can be done because someone else created a diagram like that over here, but that person isn't here anymore, and I can't locate his diagram. Oh well. Thanks for your reply. Show quote "Russell Fields" wrote: > Rich, > > If you have Visio 2003 for Enterprise Architects you can "forward engineer" > your Visio diagram into the necessary CREATE statements to make a database > based on your model. Then, inside SQL Server you can create a diagram. But > there is no diagram to diagram move feature. > > If you are using a more recent version of Visio this post > http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=969126&SiteID=1 > comments as follows: > > Visio 2007 Standard/Professional itself does not support forward engineering > the the SQL server. Only the Visio for Enterprise (VEA) which shipped with > Visual Studio Team Architect support the forward code gen functionality. > > I believe that the above is true for Visio 2005 as well. > > RLF > > "Rich" <R***@discussions.microsoft.com> wrote in message > news:C56FC3C3-8A7E-46DC-B57B-ECD6583365BF@microsoft.com... > >I have seen database diagrams of a sql server(2000) database in > >Visio(2003). > > I need to create a similar diagram in visio with my DB. Anybody know how > > to > > do this? I opened up Visio, selected New/Databases/Diagram... then what? > > > > Thanks, > > Rich > > > Rich,
Reverse Engineering (supported in most versions of Visio) is reading the database to create a drawing. "Forward Engineering" (or 'create scripts', 'create database', etc.) is creating a database from the drawing. With the version restrictions as mentioned before. RLF Show quote "Rich" <R***@discussions.microsoft.com> wrote in message news:45567627-D597-498F-AC70-F5704D83D43A@microsoft.com... > Thanks. I have visio 2003. I did not see an option for Forward > Engineering > (after selecting Database). But I did see an option for Reverse > Engineering. > I am guessing that may be the same thing. When I select that option from > the Database menu, I set up a connection to my server - click OK, and it > imports a list of all the tables in my DB. Then I drag the tables onto > the > canvas (or whatever they call the drawing form). I will have to play > around > with it a bit. One problem I am having is that I can't shrink the table > field list for tables with lots of fields. And I am having a problem > stretching the canvas to fit all my tables. I know it can be done because > someone else created a diagram like that over here, but that person isn't > here anymore, and I can't locate his diagram. Oh well. > > Thanks for your reply. > > "Russell Fields" wrote: > >> Rich, >> >> If you have Visio 2003 for Enterprise Architects you can "forward >> engineer" >> your Visio diagram into the necessary CREATE statements to make a >> database >> based on your model. Then, inside SQL Server you can create a diagram. >> But >> there is no diagram to diagram move feature. >> >> If you are using a more recent version of Visio this post >> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=969126&SiteID=1 >> comments as follows: >> >> Visio 2007 Standard/Professional itself does not support forward >> engineering >> the the SQL server. Only the Visio for Enterprise (VEA) which shipped >> with >> Visual Studio Team Architect support the forward code gen functionality. >> >> I believe that the above is true for Visio 2005 as well. >> >> RLF >> >> "Rich" <R***@discussions.microsoft.com> wrote in message >> news:C56FC3C3-8A7E-46DC-B57B-ECD6583365BF@microsoft.com... >> >I have seen database diagrams of a sql server(2000) database in >> >Visio(2003). >> > I need to create a similar diagram in visio with my DB. Anybody know >> > how >> > to >> > do this? I opened up Visio, selected New/Databases/Diagram... then >> > what? >> > >> > Thanks, >> > Rich >> >> >>  |
|||||||||||||||||||||||
Other interesting topics