I have a development server set up in my drush aliases as @dev, and a UAT server set up as @uat. I can successfully execute drush commands locally on both servers, and I can execute remote commands from UAT to the development server (e.g.
drush @dev cc all or
drush @dev upc or whatever). However, when from the UAT server I execute
drush sql-sync @uat @dev
it appears to work, but when I first make a change on UAT and then sync and then check the same page on dev is has not changed. I have tried
drush @dev cc all afterward to make sure there is no caching problem, but this doesn't help.
What could I be missing? Or what could be failing? How can I troubleshoot this?
UPDATE (corrected): If I log into @dev and execute the same command (in other words, having @dev pull data from @uat rather than having @uat push data to @dev) it works. But I'd still like to get it working when executed from @uat.