Reverse Engineer 2005 SQL Tables

[Rita]

I have Visio 2003 for Enterprise Architects SP2 loaded on my laptop. I also
have a local server defined that is mapped to a SQL Server 2005 database.
When I try to reverse engineer tables from the local server, not all tables
are displayed in the wizard's list of tables. And, when I reverse engineer
one of the tables from the wizard's list, not all of the column in the table
are brought back to Visio. Any suggestions?

 

[Barb Way]

Visio's DB modeling solution will retrieve schema information only for
Databases / Tables / Objects which are contained in the instance that you
connect to. Schema information for linked servers / databases will not be
retrieved during a Reverse Engineer process.

Another thing that might get in your way is the Ownership of the tables /
objects. The modeling solution returns info only for objects owned by
"dbo", and will ignore objects that are owned by other SQL identities.

Barb Way
Product Support - Visio
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Rita]

Visio's DB modeling solution will retrieve schema information only for
Databases / Tables / Objects which are contained in the instance that you
connect to. Schema information for linked servers / databases will not be
retrieved during a Reverse Engineer process.

Another thing that might get in your way is the Ownership of the tables /
objects. The modeling solution returns info only for objects owned by
"dbo", and will ignore objects that are owned by other SQL identities.

Barb Way
Product Support - Visio
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights

 

[Rita]

Thanks Barb. The tables that weren't being shown in the wizard didn't have
"dbo" as part of the name.

Rita