Toad World® Forums

Add Single Schema Object Compare to Toad Automation

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

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

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

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

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

Cheers,

Paul

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.