I am trying to make all the model changes in Logical model and I don't see a way to sync these to the physical model other than deleting and recreating the physical model. Is there a macro available to sync these models on demand? Please help. Thank you.
You don't need a macro, you need to use the Compare and Merge feature in ER Studio to compare the Logical to Physical and merge the changes to the Physical. The Compare and Merge feature is the sync process.
I don't see an option to compare logical to physical. Would you please point out the options I have to choose to be able to do it. I have bee using this option to create the change DDL by comparing the live DB and the physical model only. Thank you
When you launch the Compare and Merge Utility from the Logical model, you will choose the option 'Compare against another model in this DM1 file on the first page of the wizard. After clicking next, it will give you a list of the Physical models in the DM1 file - choose the appropriate model / submodel. The rest of the wizard is basically the same as when you compare the Physical to the database, choosing your options and objects. At the end, you'll be able to choose the Merge to Target option to move the differences into the Physical model.
Powered by IDERA