Push staging data to live site with Data Update Script
I understand the best way to update a live database is to use install/upgrade scripts. That works fine. However in the staging site I have extensions that I have setup and installed a lot of data into. Eg. Dealer Locator with 500 dealers.
I know you can use a data upgrade script to push that to the live server but how do I create that script. Manually wouldn't make sense. Is there a way to export the data to a script from Magento ?