Hi,
I'm having a hard time to reverse merge the difference between my model and my database schema.
The initial goal is simple :
1/ detect metadata differences
2/ have SDDM generate DDL alter code
(if possible, otherwise, recreate, reload : powerful existing feature BTW)
3/ deploy
4/ check/confirm that no more delta existing
I'm doing that by :
* menu File > Import > Dictionary
* select Connection
* select db schema
* check "Swap Target Model"
* select MY_MVIEW > Next (1 TABLE DB Object to be imported) > Finish ("Generate Design" working)
* in Compare Models window I deselect all, minus MY_MVIEW table AND also MY_VIEW Materialized View
(as they appear as 2 objects in SDDM)
* button DDL Preview
I see :
- comments created first (whereas the MVIEW is to be recreated)
that is of less importance but still blurs the readability
- MY_MVIEW is systematically recreated
(how many times ever I deploy)
I figured out :
. both SDDM objects table (relational, implemented as MVIEW) and MVIEW (physical) host the query independantly
. even if I sync them manually (copy-paste), DDL code deployed is not strictly the same as
So may it have to do with a compare dysfunction ?
SDDM is full of options do desensitize compare (exclude physical, storage, etc.) but I haven't found my way to simply compare and align MVIEWs
(and documentation is scarce on the topic)
Any hint ?
Thx