Is there a way to change the database platform for a physical model via a macro? Looks like the properties I found are just read-only.
I am trying to switch all diagrams to 12c platform.
I don't think this is possible. What you'll have to do is to is create a macro which would generate a new physical model from the logical.
Thanks Stan. Unfortunately too much work has been done on the physical already that re-generating a new one is not an option.
The problem with changing database platforms is that there are many things that don't get converted properly so it's usually safer to generate a new physical from the logical.
Depending on what information you've done in the physical, you should be able to compare most of that to the logical and then in turn compare it back to the 12c physical. That will prevent many of the errors that could happen when just changing the database platform from one to another.
You can do a submodel sync as well for any display formatting.
Thanks for the valuable info. I'll give it a shot.