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. It's 100% free, no registration required.

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?

2 Answers
2

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.