Anyone replicated a sql server db into AWS using NATIVE replication NOT AWS DMS

Question

Just a yes / no hopefully.

Can you replicate into a sql server rds multi az aws instance from an on premise sql server (standard edition 2008r2)

I know there is aws dms and im not asking about that.

There is aws directory services which i believe allows you to see an aws rds db as if its on your network and this may solve some of the issue as you need to be on the same domain or something for native replication.

This link says RDS doesnt support replication but is that only when its the master and not when its an read only replica destination. Its not really clear.

Answer 1

The answer currently is no, I believe.

I have looked at using linked servers, but that currently does not work for this situation either. From the below link:

https://aws.amazon.com/blogs/database/implement-linked-servers-with-amazon-rds-for-microsoft-sql-server/

Every person/resource I have spoken to in AWS point me to DMS, which as your describe in your question is not what you are looking for.

The only other place I came across in my travels and dugout of my bookmarks was this company https://www.attunity.com/products/cloudbeam/attunity-replicate-amazon-rds-databases-amazon-ec2/ and this product. But I have not tried it so I cannot speak if it is any good or not for what you want. But may help you.

Answer 2

Also we have noticed that the DMS fails to delete records for the tables with composite primary key. It works for table with single primary key coumns