Does Visio supports Oracle 10g

[thirumaran]

Hi

I am very new to Visio , i am famillar with Silverrun,Rational & ER-WIn .
I had been modelling oracle databases with these tools, i had a debate with
my friend regarding the features of visio for which we require clarifications
to proceed further on which tools to use Visio vs other tools for modelling
an oracle db erd.

Can i use VISIO to model an ORACLE DB . I have a DB in Oracle 10g R2

1) can i reverse engineer oracle 10g DB into visio model do changes to the
design (add few column ,remove few columns etc)..
2) Does Visio supports all oracle 10g Datatypes.
3) Can i also create an Oracle db using Visio (ie) create oracle 10g
tablespace,rollbacksegments etc... in visio so that in the forward
engineering script i can the Oracle scripts.
4) Are domains avaialabel in visio (ie) for every datatype i create a domain
5) Can i have subschemas & can these been shared. (ie) multiple users can
access different subschema and the changes will be done automatically in main
schema

Thanks in adv
Thirumaran

 

[Al Edlund]

regarding using visio to access an oracle db, it uses an odbc process so
it's a question of the driver the user selects.
Since it is odbc your question of custom datatypes is also out of visio's
control. It is not intended as a shared access tool.
Sorry for all of the indirect maybe's and no's,
al

 

[thirumaran]

Thanks Al Edlund,

More precisely what i would like to know is whether we can generate a oracle
10g physical model from a VISIO 2003 logical model which is generic.

thanks
Thirumaran

:

 

[Al Edlund]

the forward engineering supplied in visio is done in the version that comes
with vs.net enterprise architect edition. If you check the data modeling
user group you'll probably get more accurate information/feedback than I can
supply (I usually just watch from the side)
al