Reverse Engineer 2005 SQL Tables


R

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?
 
Ad

Advertisements

B

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.
 
R

Rita

Barb Way said:
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
 
Ad

Advertisements

R

Rita

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

Rita
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top