I'm tasked with upgrading our Magento installation from v1.7 to v1.9, using this article as a guide. The upgrade works fine, but its not very compatible with our development and deployment process.
Any updates are done in the development environment, then deployed to staging, and once they're tested and validated, it gets deployed to production. Our deployment process is pretty straight forward, its basically just a matter of checking out the Git branch with the new code. And there aren't too many database changes that get done, so if there are, then that just consists of manually running the MySQL queries either before or after the branch is checked out.
This is where the upgrade process for Magento somewhat clashes with our deployment process. Without knowing exactly what MySQL queries the upgrade/install process runs (if any), we basically have to follow the entire upgrade process, and once its done, just overwrite all the files with whats in our git repo.
It would be much easier if I could just run any queries that magento executes myself. Is there a way to find out what queries Magento would execute? If not, can someone provide the queries for the 1.7 -> 1.9 upgrade?