Table selection in Reverse Engineering Wizard of Visio 2010

Question

 

Hi,

Microsoft Visio Premium 2010

Version: 14.0.6

OS: Windows XP

I am able to generate Database model diagram from an existing Oracle database using Reverse engineering process.

However, my questions related to table section to the technical forum are:

1. Reverse engineering wizard lists all the Oracle tables (apart from views/stored procedures). Since the number of tables on my Oracle database is huge, rather than ticking the check box beside the table name, is there any other way to select the tables for generating database model diagram?

(Eg: query. If so, where could we write it?)

2. Reverse engineering wizard lists all the Oracle tables from all schemas. Is it possible to restrict the database model diagram to a single Oracle schema?

Thanks

Srinidhi Rao

Answer 1

Hello,
 
Thank you for your post.
 
This is a quick note to let you know that we are performing research on this issue.

Thank you for your understanding and support.

---

William Zhou

TechNet Community Support

Answer 2

Hello Srinidhi,

When I test this on my system using Visio 2010 I have a "Select all" or "Deselect all" button on the bottom of the table selection window. In my testing I don't see how you can just select one schema from any database type.

Thank you,

---

Sr. Support Engineer - Microsoft Word

Answer 3

Hello Paul/William,

Thanks for your reply.

Yes exactly, wizard lists all the Oracle tables from all schemas.

Rather than identifying tables belonging to a schema (which is tedious if there are huge number of tables) and ticking the check box beside the table name, is there any way to list schemas and corresponding tables from database for generating database model diagram?

if not, it would be really helpful to include this feature in the future release.

Thank you,

Srinidhi Rao