Comparing user objects problem

[Kuba]

I'm using "compare user objects" option to generate patch file for old database which stands on patron's server when I what to upgrade application. There is a problem when some triggers are in old database and there are not in new. In generated file there is no "drop trigger..." statement. I understand that PL\SQL Developer compares only that object, which exists in source db. But trigger is a part of table and it should be dropped.
The same problem is with procedures and other objects which are in target database and are not in source database.

Kuba Kr

 

[Marco Kalter]

The Compare User Objects tool will indeed not drop objects, which is quite dangerous of course. Maybe we can add an option in the next release that will allow you to do so. I have added this to the list of enhancement requests.

------------------
Marco Kalter
Allround Automations

 

[Kuba]

Originally posted by mkalter:
The Compare User Objects tool will indeed not drop objects, which is quite dangerous of course. Maybe we can add an option in the next release that will allow you to do so. I have added this to the list of enhancement requests.

Yes, it could be an option. Thanks!