Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a local infrastructure with multiple SQL Servers. Some of the servers have replications services to copy some data to a master database. Is it possible to have the replication services to work on a RDS SQL Server instance? Or do I need to have a EC2 instance with SQL Server and configure the service by myself?

share|improve this question
up vote 1 down vote accepted

In SQL Server RDS, you have DBO access to your databases and the ability to schedule jobs, but that is about it. Amazon is now your DBA. Restoring or renaming databases, setting up replication, etc. is restricted.

share|improve this answer

RDS is very restrictive. Many of the vanilla SQL Server standard features are not available on RDS. But you can use the Cloudbasic tool on the AWS Marketplace to replicate RDS. It works even for RDS SQL Web Edition.’blg2’

share|improve this answer

Found the answer in the Amazon documentation. The replication feature is currently not supported.

share|improve this answer
I'm wondering though, is it possible to stand up an EC2 instance that can perform transactional replication as a publisher/distributor to an RDS subscriber? Has anyone tried this? – Queue Mann Jul 22 '15 at 18:21

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.