Share via

Merge Replication across different network

Naveena Jaineera 41 Reputation points
2021-09-15T13:11:32.52+00:00

Hi Experts,

I wanted to setup establish merge replication between 3 azure VMs (1 Publisher and 2 Subscribers). All VMs are residing in different geographies. How do we share the snapshot created so that it would be available to subscribers?
Can some one explain briefly... I was able to setup in same network, but sync is not happening if I setup across different networks using public IPs.

Thanks,
Naveen J V

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

Answer accepted by question author

Seeya Xi-MSFT 16,676 Reputation points
2021-09-16T03:26:28.877+00:00

Hi @Jcho360 ,

Please refer to this MS doc: Configure Web Synchronization.
There is an article with screenshots attached to it for you to better perform related operations: https://www.mssqltips.com/sqlservertip/4386/configure-sql-server-merge-replication-with-web-syncronization/

Best regards,
Seeya

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jcho360 1 Reputation point
    2021-09-16T17:30:07.607+00:00

    my question is, is there a rule of thumb to set the RAM memory on SQL Server Always-On? or should I use the same that is being used for SQL Server Single Instance

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.