You would move to RDS the minute you know you're committed to AWS and know that you don't want to
worry about things like backups, upgrades or clustering. The disadvantage to doing so is that you
lose a lot of administrative privileges to the database server itself and you don't get access to
the filesystem or underlying OS. We had trouble migrating a sizable SQL Server installation onto RDS
because it had a ton of triggers and stored procedures (SPs) that relied on files in the filesystem.
Comments
You would move to RDS the minute you know you're committed to AWS and know that you don't want to worry about things like backups, upgrades or clustering. The disadvantage to doing so is that you lose a lot of administrative privileges to the database server itself and you don't get access to the filesystem or underlying OS. We had trouble migrating a sizable SQL Server installation onto RDS because it had a ton of triggers and stored procedures (SPs) that relied on files in the filesystem.
Yeah, well. That’s SQL Server for you. There’s a lot of things that RDS can’t do for you in the SQL Server flavor.
RDS MySQL != RDS Postgres && RDS (MySQL || Postgres) >> RDS SQL Server