How Do I Prevent Deletion of Objects in the Destination Database?In Datanamic SchemaDiff there is an easy way to prevent deletion of objects in the destination database. The select all and deselect all buttons apply only to the shown objects. By default all objects from both databases are shown. You can only show the objects that will be deleted and then deselect all at once them by pressing the deselect all button.
To show only the objects to be deleted leave the red arrow (drop) button pressed and click the identical, alter and create buttons to become not pressed.
Figure 1: Filter button setting to show only objects to be deleted.
Now press the deselect all button. Datanamic SchemaDiff will not include the script anymore to delete any objects. If you only want to skip deletions of procedures for example, you can use the same procedure but then make sure that only the drop button and the procedure button are pressed.