Description:
In many cases, users do not want to Reverse Engineer (RE) all objects from a database but would like to only RE specific tables or objects as desired. How can they do that using CA ERwin Data Modeler R7/R8/R9?
Solution:
That functionality is not part of Reverse Engineer proper. If you want a list of available tables to choose from, please use Complete Compare to do the Reverse Engineer.
First, create a brand new model. That will be the left model.
Second, go to Actions | Complete Compare.
You should be on the link 'Right Model'.
In Load From check on Database/Script and also check on Allow Demand Loading.
Click Load, New Model, next, the Reverse Engineer window comes up. Click Next, connect to your database and that model is imported as the right model into the complete compare wizard.
Now click the link Right Object Selection and expand Tables. Check on just the tables you want to import into your left model.
Press compare.
Collapse all rows and expand tables.
Do a To Left to import the tables into the left model from the right model.
Press Finish.
Close the right model
Now you have a blank Left model in erwin. The objects need to be added to the diagram to become visible.
In the Model explorer expand entities
Right-click the entities and choose to Add to Diagram.
The tables will now appear in the model.
NOTE: Alternatively you could go into ER Diagrams and edit the diagram to set that to Auto-populate to add all the entities to the diagram.
Comments
0 comments
Please sign in to leave a comment.