Push or Pull?
Attempting a migration from a remote server to a local server will never be possible.
Instead, initiate a pull from your local environment (sucking the data down from your remote server) or initiate a push from your local environment (transferring the data to your remote server).
This illustration may help: