We have a group that has opted to have a SQL Server db server replicated to a SQL Server db server in a cloud host. The problem we have with this is that the local source server has to connect to the target db server via cloud host vpn. Is this a bad idea? Also this group is using merge replication. The db server being hosted in the cloud host serves as a standby server that they light use as well. Should they use log shipping or some sort of transactional replication instead of merge replication? Please advise.