I can synchronize between my model in DM and the Data Dictionary of a database in 2 different directions.
1.) Synchronize Data Dictionary with Model
This direction works fine. All changes in tables and all new tables in model are found.
2.) Synchronize Model with Data Dictionary
This direction does not work as expected.
Changes in tables are found - ok.
Tables that are dropped in Data Dictionary are found - ok.
Tables that are new in Data Dictionary are not found - why?
Also all other new objects like views, sequences are not synchronized.
I am using DM V 188.8.131.527
How can I identify and copy new tables from Data Dictionary back to the model, if they do not already exist in my actual model?
thanks for your fast answer and sorry for my late reply.
The Data Dictionary Import Wizard is indeed able to import new objects, but seems to be not designed to do that.
The default setting when I start this wizard is to import only existing objects, not the new onces.
Since I found no option to invert this selection or to select only all new objects to import, it is theoretically possible but practically not so easy.
Since the wizard seems to know which objects are existing it could be possible to provide the option to import new objects.
Do you know any direct way to import all new objects?
I logged an enhancement request about option to import only new objects.
But even now you can do the job with some overhead:
1) select everything in import wizard
2) In compare dialog:
- deselect all objects
- use filter(s) to see only new objects
- select all visible objects
You can use tree view or tabular view there - they have different advantages so you need to see what fits better for your job.
thanks for logging the enhancement request and also for the workaround. This hint is saving a lot of time.
I have one additional warning.
If you filter to see only new objects and you are selecting the hole table tree, then also the hidden objects are selected.
So you should remove the filter in the last step and double check to ensure that only new objects are select.