Home › Forums › Product Support Forums › Ajax Search Pro for WordPress Support › Deploying db changes between staging and production › Reply To: Deploying db changes between staging and production
Hi, Ernest.
My goal is to generated diff script for deploying changes between staging/production environments, so that only needed changes will be deployed.
Was wondering if changes to db can be detected with sql compare tools like Toad for MySQL?
Made a little test:
1) Tried to change the setting as in GetImage.png
2) Exported tables of the plugin:
{prefix}_ajaxsearchpro etc..
with sql dump.
before and after change.
3) Imported the dumps to different local dbs
4) compared them with Toad and couldn’t find the difference.
Or alternatively, there’s need to import the dump as is?
Thanks in advance.