MS-SQL access

[raul]

is there a way for Visio to read the MSSQL engine. I want it to read a
database and plot the tables, keys, etc.

Is this possible in visio 2003?

Thanks,
Raul Rego

 

[Chris Roth [MVP]]

Hi Raul,

I think you can get at any DB that supports ODBC.

The text below is directly from the help file for Visio's Re-engineer
Database Wizard:
------------------------------

To create a connection, you specify an installed Visio driver and the 32-bit
ODBC (Open Database Connectivity) data source. For convenience, before you
run the wizard, you should set the default Visio driver and target database
to the target database you want to reverse engineer.

The schema definition information that the wizard can extract depends upon a
combination of things, such as the capabilities of the DBMS (Database
Management System) and ODBC driver. To the extent that it is available from
the target DBMS, you can select the schema definition information that the
Reverse Engineer Wizard will extract.

------------------------------


--
Hope this helps,


Chris Roth
Visio MVP

Free Visio shapes:
http://www.visguy.com/category/shapes
Visio programming info:
http://www.visguy.com/category/programming/
Other Visio resources:
http://www.visguy.com/visio-links/

 

[raul]

thanks, will play with it tonight.

Hi Raul,

I think you can get at any DB that supports ODBC.

The text below is directly from the help file for Visio's Re-engineer
Database Wizard:
------------------------------

To create a connection, you specify an installed Visio driver and the
32-bit ODBC (Open Database Connectivity) data source. For convenience,
before you run the wizard, you should set the default Visio driver and
target database to the target database you want to reverse engineer.

The schema definition information that the wizard can extract depends upon
a combination of things, such as the capabilities of the DBMS (Database
Management System) and ODBC driver. To the extent that it is available
from the target DBMS, you can select the schema definition information
that the Reverse Engineer Wizard will extract.

------------------------------


--
Hope this helps,


Chris Roth
Visio MVP

Free Visio shapes:
http://www.visguy.com/category/shapes
Visio programming info:
http://www.visguy.com/category/programming/
Other Visio resources:
http://www.visguy.com/visio-links/