Transactional Replication from OnPrem MSSQL instance to Google Cloud (GCP) MSSQL

  • Narodul

    Newbie

    Points: 2

    Hi,

    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.

    Thanks

  • Site Owners

    SSC Guru

    Points: 80378

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply