DB2 10.5 on Windows
I am looking for a good tool (free is better) that will compare one DB2 database to another. I want to be able to compare our production to our staging to make sure they are in sync before we do testing. I have one named SQL Power Architect what works pretty well but it only allows you to compare one schema at a time. I have over 30 schemas so that wouldn't be ideal.
There is one called DTM Schema Comparer that will do what I want and I can schedule it, but it has a cost associated with it and before I go begging for money I just wanted to be sure there is not a similar free tool.
So I need it to compare all schemas, not one at a time, generate a readable report and SQL change file and be run from command line.
Tall order but if you don't ask, you don't know.