When using CTS, there is no configuration in CTS that will only ALTER objects in the Target Instance instead of running Drop and Create. The entire design of CTS operations on mirroring via drop/delete and create/insert. It would be great DSP CTS features if you can have an option to only Alter objects so we can keep and track the histories of objects.
Thank you for logging this idea. Currently there are no plans to change the drop create functionality around the CTS package import processing but we will consider this as we look to improve CTS in the future. With the 6.7 and 6.7.1 releases of the DSP we have made a number of improvements to the CTS capabilities that I would recommend you take a look at to see if this has improved your UEX around CTS package creation and review.
Attachments Open full size