SQL Server assessments Target (RDS/EC2)


Hi Team,

We are assessing the SQL server and found from the SCT report that the features below are used on-premises. Please suggest how we can decide target(RDS/Custom RDS/EC2).

  1. Full-Text search
  2. Service Broker
  3. SQL Server Agent Jobs
  4. Linked server ( MSSQL, Oracle)
  5. Alerts
  6. Data compression
  7. DB Mail configurations
  8. High Availability: Cluster and Always on

As of now, I got some limitations for each feature. Please suggests to me what things we can consider while deciding the Target.


1 Answer

When deciding between Amazon RDS, Amazon RDS Custom, and Amazon EC2 for your SQL Server migration, you should consider the features you need, the level of control and responsibility you want, and the costs involved. Licensing is a big part of your decision to go with RDS or EC2. Only with EC2 can you bring your own license for SQL Sever with SA which can drastically reduce the cost. You can use license included on EC2 or RDS. Here is a rundown of the features you've mentioned and how they may affect your decision:

Full-Text Search: Amazon RDS for SQL Server supports Full-Text Search. So, you can use either RDS or EC2 for this feature.

Service Broker: Service Broker is supported for Amazon RDS, but Service Broker endpoints aren't supported on Amazon RDS. But RDS custom and EC2 support this feature.

SQL Server Agent Jobs: Amazon RDS for SQL Server supports SQL Server Agent Jobs. So, you can choose either RDS or EC2.

Linked Servers: Amazon RDS for SQL Server supports creating linked servers to other Amazon RDS DB instances running SQL Server. For linked servers to other database systems like Oracle, you need EC2 or RDS Custom .

Alerts: You may use Amazon CloudWatch with RDS for receiving alerts. EC2 and RSD Custom gives you more control over custom alerts.

Data Compression: Amazon RDS for SQL Server supports data compression. You can use either RDS or EC2.

DB Mail Configurations: RDS supports Database Mail for all SQL Server versions on the Web, Standard, and Enterprise Editions. You can use either RDS or EC2.

High Availability: Cluster and Always On: Amazon RDS for SQL Server does not support SQL Server Always On Availability Groups or Failover Cluster Instances. Amazon RDS provides high availability using a Multi-AZ deployment, which might be sufficient for your needs. If you need Always On or Clustering specifically, you would have to use EC2.

answered a year ago
profile pictureAWS
reviewed a year ago
  • Thanks for inputs/suggestions.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions