Wednesday, March 28, 2012 11:21 AM
Microsoft Visio Premium 2010
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?
Tuesday, April 03, 2012 7:29 AMModerator
Friday, April 06, 2012 3:03 PM
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.
Sr. Support Engineer - Microsoft Word
Friday, May 04, 2012 1:57 PM
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.