A question from the innerwebs –
please, is it possible to define and save a (sub)set of objects for comparison? In Databasediff wizard we have an option to define objects, but it’s a bit cumbersome to do the same thing over and over again, so it would be highly useful to save options and selected items for comparison for future use.
Thanks a lot,
The answer is, Yes!
Use the Cart!
Define the objects to be used for the compare using Cart. Find them in your target database. Drag them to a cart.
I’m going to add 3 TABLES from HR.
Now I’m going to invoke the DIFF using the DIFF button on the Cart toolbar.
I need to change my CONNECTION to the Target Instance (HR_COPY) and click ‘Apply.’
And now we’re only going to compare those 3 tables.
And then we’ll get our results, as you normally would using the Database Diff item on the Tools menu.
More on the Cart
The Cart can do a LOT.
More on Database Diff
PS What about PL/SQL?
Yeah, you can drop that into a CART and do a DB DIFF to compare your PLSQL objects as well.