Database refresh does not create foreign keys

P

peter.hattam

I have reverse engineered a Oracle 10G database into Visio. Somehow a
parent table got deleted and the FK column in all the child tables
were deleted as well.

When I try to refresh the model, the Refresh Model wizard picks up the
missing table and indicates that the FK column will be added to all
the child tables (as expected). However after the wizard completes,
the parent table is captured, however there has been no changes to the
child tables.

I am using Visio 2007 and have tried using several different Oracle
ODBC drivers with no luck.

Any ideas
 
B

Barb Way

Try forcing Visio to re-display the Relationships that create the FK
columns :
Right-click on the Table and select "Show Related Tables"

If that doesn't work, then the issue is that the Relationships are not
contained in the model any longer. If that is the case, you will be better
off starting with a clean Reverse Engineer. There are no tools to repair
the db schema 'guts' if the option above does not help.

Barb Way
Product Support - Visio
Microsoft Corporation
[This posting is provided "As Is" with no warranties, and confers no
rights.]
--------------------

I have reverse engineered a Oracle 10G database into Visio. Somehow a
parent table got deleted and the FK column in all the child tables
were deleted as well.

When I try to refresh the model, the Refresh Model wizard picks up the
missing table and indicates that the FK column will be added to all
the child tables (as expected). However after the wizard completes,
the parent table is captured, however there has been no changes to the
child tables.

I am using Visio 2007 and have tried using several different Oracle
ODBC drivers with no luck.

Any ideas
 

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