Overwrite behaviour in Object Shopping
This topic describes the overwrite behaviour for Object Shopping via an export file. For the behaviour with copy-paste, go to "Conflict Resolution" in help topic: Object shopping via the clipboard (copy-paste).
When objects are imported in a target repository, they are imported as-a-whole. The standard 'UPSERT' algorithm (a mix of UPDATE and INSERT) is applied:
For example, if you import a Table object and the Table already exists in the target repository, the Table record will be updated. Columns and indexes which do not exist in the target repository will be added, columns and indexes which exist in the target repository and in the file will be updated and columns and indexes which exist in the target repository but do not exist in the file will be deleted.
Another example is a Job with its Job Tasks: the import mechanism will insert, update and delete the Job Tasks in the target repository in such a way that they will reflect the situation in the file.
If the overwrite behaviour does not raise errors for any of the objects in the export file, the import will be automatically committed. Otherwise, an error message will appear, the entire import attempt will fail, and the transaction will be rolled back.