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?
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.
Found the answer in the Amazon documentation. The replication feature is currently not supported.
You can also use the Amazon Database Migration Service. https://aws.amazon.com/dms/
As per the FAQ's:
Q. In addition to one-time data migration, can I use AWS Database Migration Service for continuous data replication?
Yes, you can use AWS Database Migration Service for both one-time data migration into RDS and EC2-based databases as well as for continuous data replication. AWS Database Migration Service will capture changes on the source database and apply them in a transactionally-consistent way to the target. Continuous replication can be done from your data center to the databases in AWS or in the reverse, replicating to a database in your datacenter from a database in AWS. Ongoing continuous replication can also be done between homogenous or heterogeneous databases. For ongoing replication it would be preferable to use Multi-AZ for high-availability.
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.