• How will you tell where to send data? How can you tell if a user is from a country?

    You can certainly use something like bidirectional transaction replication to move data. You can also use Service Broker to build two one-way pipes, though preventing loops of changes can be an issue there.

    The VPN doesn't necessarily improve performance, and can hurt it. It's more about security.