How to Compare a Specific Subset of DB Objects

A question from the innerwebs –

Hello,

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!

We have a nice Oracle By Example on this topic available here.

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.

Open the 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 pick my HR_COPY connection for the Destination Connection.

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.

Sweet.

And then we’ll get our results, as you normally would using the Database Diff item on the Tools menu.

I’m missing some important stuff it appears.

More on the Cart

The Cart can do a LOT.

Exporting Multiple Tables to a Single Excel file using the Cart

Use the Cart to Build Deployment Scripts

Introducing the ‘Shopping’ Cart

Batch Load Your Cloud via the Cart and our command line interface

More on Database Diff

Compare Objects from Multiple Schemas

Database Diff Enhancements

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.

It’s just a text-compare…

关注dbDao.com的新浪微博

扫码加入微信Oracle小密圈,了解Oracle最新技术下载分享资源

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569