I have 2 models, Model A and Model B. These exist in separate models (separate DM1 files). Both have their own logical and physical models. I want to merge the physical model A (source) into physical model B (target).
1. I select model A, while in the physical model, and select "compare and merge utility"
2. In the next screen (step 2 of 5), and then select "compare against another model in a DM1 or DT file" I choose Model B from the drop down, and click "Next"
3.. In this next step (step 3), it only displays the "Logical" model for the target (Model B) to choose from. I.E. No Physical Model displays to choose as the target.
So, I cannot merge into physical model B from physical model A.
However, If I start with a different source physical model, lets call that model C (in its own DM1 file, just lie model A), I can Merge and compare into the Physical Model for model B. Model B's physical model displays in step 3. That's what leads me to believe there is something wrong with Model A, and not Model B.
The only thing that comes to mind is that the database platforms are different. I would suggest doing a right-click on the physical model in the explorer tree and choose the change database platform and make sure the two models match in platform and version.
They are both SQL Server, so that's not the issue. I generated to
They are both sql server 16.
Here is what I did as a work around - I should not have to do this
I first merged Model A to the logical model in model B. Then I merged to the physical on Model B from the logical on Model B. Then I saved Model B as (a new) Model C. Then I made some changes in Model B physical. Then I merged from Model B physical, and it gave me the option to select physical on Model C. The merge worked then .
So, it appears that Model A is now "corrupt", for lack of a better term.