Add Single Schema Object Compare to Toad Automation

Toad for Oracle Idea Pond
1

I often need to spot check number of objects here and there in my databases.  I neither need nor want a full schema compare, just a number of spot checks (in the dozens) that would be nice to automate.

Thanks,

Paul

2

Have you tried using the "Object Set" tab?  You can use that to just compare specific objects instead of the whole schema.

3

Thanks for the response.  In this case I am comparing between servers and a file.  The single object compare works great for this.

Thanks,

Paul

4

Oh, OK.  So are you looking for just a pass/fail on if it matches or not?  

5

Yes,  that is the idea.  An automation that runs and tells me if I need to look closer at a given object.  

Cheers,

Paul

6

Hey Paul -  Not saying I won't do a single object compare action too, but I just added a 'compare files' action for next beta.   That's been on my to-do list for a while and you can use it with an export DDL action to accomplish this.   It'll return true/false so you can use it with an if...then action and email to be notified on file diffs.