Toad World® Forums

Reverse engineering a New table into an existing Model


We have a SQLSERVER 2005 Model. This model was Reverse Engineered from a SQLSERVER 2005 Database.

When we created the model we forgot to bringin one of the two fact tables in the Star Schema.

Now, how do we bring the other fact table into the existing model?




you can either use Model Update (Model | Model Update) or reverse engineer the two tables (or the two tables and other objects that have something to do with the two tables) as a new model and use Model Merge to add missing objects to existing model or simply do another reverse engineering to load everything you want.




Vaclav - Thanks a lot. Appreciate your help