Visio 2003 Pro to document SQL servers

[.·:m·a·r·l·a:·.]

Hello everybody

I am try to document a Microsoft-SQL server with couple of databases, lots
of views and tables and few store procedures in each,and few jobs comon for
both

I have use the menu Databases -> reverse engineer , but i found some
limitation:

- need to import one by one database
- jobs are not possible to import
- sp do not have graphical representation
- views are not related to the tables/views from where they come

is it me or is visio that do not allow any of the previously possibilities
??

my neededs are to make a big drawing to examinate how a sql server works
(servers to be remodelate), there by I would need a complete picture of the
server

thansk in advance

 

[Chang Oh]

You are correct in couple of your observations. You can only reverse
engineer one database at a time. Visio is designed with this limitation
because of the fact that you can only connect to one database at a time with
an ODBC driver. Also, there is no graphical mapping for SP or any other
code objects.

As for jobs, I am not sure what they are.

As for the views, Visio attempts its best to relate to the originating
tables by parsing the column definitions. You can see most of the
derivations by examining the View column properties. However, there is no
graphical means to display the connection to the tables/views from which a
given view is derived.

Chang Oh
Visual Studio Team Architect
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.