I'm wondering if anybody here has any experience of transaction replication from an OnPrem publisher to a subscriber on a GCP-hosted Windows instance? MSSQL -> MSSQL.
Can it be done? (I assume "yes".) Is it essentially the same as OnPrem for both (but with extra latency), or are there particular challenges to overcome? I'm asking now, as I'm about to attempt to do so, and I'm hoping to leverage the experience of others to hopefully make it less painful, or rule it out as an option. (Cloud SQL is not an option). What online resources are there that have been useful in the past? Googling only directs me to GCP documentation focusing on Cloud SQL.
My current setup is:
MSSQL 2016 SP2 Enterprise -> (MSSQL 2016 Std) *4 subscribers, all of which are OnPrem, across 2 datacentres.
Happy to answer any (most) questions.