MSSQL REPLICATION CONFIGURATION ISSUE

Question

I have two sql instaces one is AWS SQL 2022 version and another on premises sql 2017 version.

AWS SQL we have to keep it as subriber with distributor means pull replication

On premices we have to keep it as a publisher .

Both are different domains

we need complete guide for this we have tried all the possibility way if you have the solution kindly let us know

Answer 1

For a complete (= very much to read) documentation about SQL Server replication, see

https://learn.microsoft.com/en-us/sql/relational-databases/replication/sql-server-replication

Answer 2

Hi，jestadi bala

An important prerequisite for configuring SQL Server replication between different domains is to ensure the network connectivity between the two domains is properly set up.

This depends on the type of proxy your AWS instances are using.

The official documentation already provides detailed steps for configuring local SQL Server replication services.

Additionally, there are two documents available for your reference.

https://docs.aws.amazon.com/prescriptive-guidance/latest/migration-sql-server/trans-rep.html

How to migrate to Amazon RDS for SQL Server using transactional replication

Best Regards,

Mikey Qiao

---

If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.