Visio2002: Database Objects Lost If You Reverse Engineer into the Same Database Model More Than Once (305634)
The information in this article applies to:
- Microsoft Visio 2002 Professional
This article was previously published under Q305634 SYMPTOMS
In Microsoft Visio Professional, when you reverse engineer a database into the same database model more than once, some database objects are lost when you update the database.
CAUSE
This issue can occur if you do the following actions in the following order:
- You reverse engineer an existing database, and then create a new database model diagram.
- You modify the database model diagram by deleting one or more database objects from the model.
- You reverse engineer the same physical database into the same database model diagram.
- You use the Update Database Wizard to update the database.
For example, after you reverse engineer a database, you can delete one or more tables from the model diagram, make other modifications, and then perform another reverse engineer operation to obtain additional objects from the physical database. If you then use the Update Database Wizard to synchronize the physical database and the logical database model, the table or tables that were deleted from the model are also deleted from the physical database.
WORKAROUND
To work around this issue, use the Refresh Model Wizard to retrieve information from your database and refresh your database model diagram. With the Refresh Model Wizard, you can compare your diagram to the database, and then address any items that are not synchronized.
To start the Refresh Model Wizard, click Refresh Model on the Database menu, and then follow the instructions on the wizard pages that are displayed on your screen.
NOTE: The Refresh Model Wizard does not detect new tables that are added to the database. If new tables are added to the database and you want to add them to your model, follow these steps rerun the Reverse Engineer Wizard, and then select the tables that you want to add. If you do not know which tables are new, click Select All in the Reverse Engineer Wizard. Only the new tables are added to the model.
IMPORTANT: To ensure that you do not lose database objects during an update process, do not reverse engineer a physical database into the same database model more than once. If you want to reverse engineer a database multiple times, do so into a new database model diagram every time.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. MORE INFORMATION
The reverse engineering and updating processes in Visio Professional are designed to allow changes to be reflected in an existing physical database. Visio maintains a record of changes made to a database model and propagates those changes to the physical database during the update database process. The reverse engineering process does not reset the record of changes for a particular database model diagram. You must reverse engineer your database into a new database model diagram if you do not want the changes that you made to the model to be propagated to the physical database during an Update Database process.
| Modification Type: | Minor | Last Reviewed: | 7/27/2006 |
|---|
| Keywords: | kbbug kbfix KB305634 |
|---|
|