I have gotten Data Compare to open up my two databases and show me the differences between two databases but I want to do some more complex things with my data once I find differences and I'm not sure if this tool can do it.
1 db in dev
1 db in prod
I want to be able to:
1)Compare all processes, templates, roles, and products for date/time differences between the Development and Production databases
2)If there is a difference, update the version number of the process
3)Change the last edited by to pdsysadmin
4)If there is no difference, then it does nothing to the process/product/templates/roles page
I want to compare the development and prod database and find anywhere where the last edited dates don't match (the system will update the last edited date but not the version).
For the differences that Data Compare finds I want to have the Production db version number field and the date/time field updated to match the Development database values. If the last modified dates on both db's match it means that nothing was touched and that row does not need to be modified.
Has anyone used Data Compare to do anything like this?