Reply To: Deploying db changes between staging and production

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

#14254
warrior7089
warrior7089
Participant

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.

Attachments:
You must be logged in to view attached files.