Re-Reverse Engineering from rebuilt Database

[Jose]

Hi,
I am using Visio reverse engineering only to show a diagram of the Database
model. The problem I have now is that the database server was rebuilt and the
SQL tables were restored within a new server name also with a new database
name.

Now if I reverse engineer the database, obviously the tables do not get
updated. On the contrary, new tables with identical names are added to the
visio diagram.

Is there a way to tell Visio "this is the database now and update existing
tables"?

 

[Barb Way]

That information is stored within the logical 'model', which you cannot
edit. You can see the information listed in the Database Properties window
along with the owner, but these values are not exposed for user editing.

At this point you should perform a fresh Reverse Engineer to a new drawing
to get a clean picture of your database.

Note that copying entites between drawings will always create new objects
also - so if you have any additional entities that you manually added to
your original drawing, you can copy them to the new drawings - but they
will be renamed "entity1", "entity2", etc. For instance, if you have a
table named "Test" and copy it to a new drawing, it will be renamed
"Test1". The entity names can be edited afterwards, but there is no way to
prevent the name during the paste action.

Hope that helps.

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

Hi,
I am using Visio reverse engineering only to show a diagram of the Database
model. The problem I have now is that the database server was rebuilt and
the
SQL tables were restored within a new server name also with a new database
name.

Now if I reverse engineer the database, obviously the tables do not get
updated. On the contrary, new tables with identical names are added to the
visio diagram.

Is there a way to tell Visio "this is the database now and update existing
tables"?