Thanks mloch, This is the only solution to this problem I have found after hours and hours of trying everything else...
To get rsync and sql-sync to work on remote server using Windows (w/Aquia) it is necessary to make changes to 2 files filesystem.inc and SqlBase.php.
First delete cygdrive/ from $path = preg_replace('/cygdrive/(\w):/', '/$', >str_replace('\', '/', $path)); in line 61 of filesystem.inc and change drush_shell_exec('gzip -d %s', $input_file)
instead of
drush_shell_exec('gunzip %s', $input_file) in line 144 of SqlBase.php
Happy Syncing!
Although in my case all I needed to do is remove the cygdrive/ in filesystem.inc...
It seemed to work fine without changing 'gzip' to 'gunzip'.
Now there's gotta be a better solution to this problem than modifying drush's code, but for now it solves the issue with rsync / sql-sync.
For clarification for others, these files are (most likely) found in:
- C:\Program Files (x86)\DevDesktop\drush\vendor\drush\drush\includes
- C:\Program Files (x86)\DevDesktop\drush\vendor\drush\drush\lib\Drush\Sql