Terjemahan disediakan oleh mesin penerjemah. Jika konten terjemahan yang diberikan bertentangan dengan versi bahasa Inggris aslinya, utamakan versi bahasa Inggris.

# Memilih antara Amazon EC2 dan Amazon RDS
<a name="comparison"></a>

Amazon EC2 dan Amazon RDS menawarkan manfaat unik yang mungkin bermanfaat untuk kasus penggunaan spesifik Anda. Anda memiliki fleksibilitas untuk menggunakan salah satu atau kedua layanan untuk database SQL Server Anda, tergantung pada kebutuhan Anda. Bagian ini memberikan informasi terperinci untuk membantu pilihan Anda.

## Matriks keputusan
<a name="matrix"></a>

Tabel berikut menyediakan side-by-side perbandingan fitur SQL Server yang didukung di Amazon RDS, Amazon RDS Custom untuk SQL Server, dan Amazon. EC2 Gunakan informasi ini untuk memahami perbedaan mereka dan untuk memilih pendekatan terbaik untuk kasus penggunaan Anda.

Untuk informasi terbaru untuk Amazon RDS, lihat [Microsoft SQL Server di Amazon RDS dalam dokumentasi](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html). AWS 

------
#### [ Development ]


****  

| Fitur pengembangan | Amazon RDS | Amazon RDS Custom | Amazon EC2 | Catatan | 
| --- | --- | --- | --- | --- | 
| Ekstensi kolam penyangga | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | Jika fitur ini sangat penting untuk beban kerja Anda, pertimbangkan untuk memilih Amazon RDS Custom atau Amazon. EC2 | 
| `BULK INSERT` | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | Lihat [Mengintegrasikan instans Amazon RDS for SQL Server DB dengan Amazon S3 dalam dokumentasi Amazon](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/User.SQLServer.Options.S3-integration.html) RDS. | 
| Change Data Capture (CDC) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (Edisi Perusahaan: semua versi; Edisi Standar: 2016 SP1 dan yang lebih baru)  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | Lihat [Menggunakan pengambilan data perubahan](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.CDC.html) dalam dokumentasi Amazon RDS. | 
| Ubah pelacakan | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  |  | 
| Indeks Columnstore | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (Edisi Perusahaan dan Standar: 2016 dan yang lebih baru)  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (Edisi Perusahaan dan Standar: 2019 dan 2022)  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (Edisi Perusahaan: 2014 dan yang lebih baru; Edisi Standar: 2016 SP1 dan yang lebih baru)  | Lihat [skalabilitas dan kinerja RDBMS](https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16#RDBMSSP) dalam dokumentasi SQL Server. | 
| Layanan Kualitas Data | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Jika fitur ini sangat penting untuk beban kerja Anda, pertimbangkan untuk memilih Amazon RDS Custom atau Amazon. EC2 | 
| Database Mail | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Lihat posting blog [Menggunakan Database Mail di Amazon RDS for SQL Server](https://aws.amazon.com/blogs/database/using-database-mail-on-amazon-rds-for-sql-server/). Kami mendorong Anda untuk menggunakan [Amazon Simple Email Service (Amazon SES)](https://aws.amazon.com/ses/) untuk mengirim email keluar yang berasal AWS dari sumber daya, untuk memastikan tingkat pengiriman yang tinggi. | 
| Database Engine Tuning Advisor | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| Pemberitahuan acara DB | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak (melacak dan mengelola acara DB secara manual) | Lihat [Menggunakan notifikasi peristiwa Amazon RDS](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.html) di dokumentasi Amazon RDS. | 
| Pemberitahuan acara DDL | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Jika fitur ini sangat penting untuk beban kerja Anda, pertimbangkan untuk memilih Amazon RDS Custom atau Amazon. EC2 | 
| Daya tahan transaksi tertunda (lazy commit) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2016 dan yang lebih baru) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2019 dan 2022)  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2014 dan yang lebih baru) |  | 
| Kueri terdistribusi | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (target SQL Server) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (target SQL Server)  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (target SQL Server) | Lihat posting blog [Menerapkan server tertaut dengan Amazon RDS for SQL Server](https://aws.amazon.com/blogs/database/implement-linked-servers-with-amazon-rds-for-microsoft-sql-server/). | 
| Acara yang diperpanjang | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| Prosedur tersimpan yang diperluas, termasuk `xp_cmdshell` | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Jika fitur ini sangat penting untuk beban kerja Anda, pertimbangkan untuk memilih Amazon RDS Custom atau Amazon. EC2 | 
| Tabel file | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Jika fitur ini sangat penting untuk beban kerja Anda, pertimbangkan untuk memilih Amazon RDS Custom atau Amazon. EC2 | 
| `FILESTREAM` | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | `FILESTREAM`tidak kompatibel dengan Amazon RDS. Namun, Anda dapat mengonfigurasi database dalam memori. | 
| Pencarian teks lengkap | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (kecuali pencarian semantik) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| Basis data dalam memori | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2014 dan yang lebih baru) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2019)  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2014 dan yang lebih baru) |  | 
| Server tertaut | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (target SQL Server, Oracle, dan Teradata) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya, dengan CEV  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Lihat [Menerapkan server tertaut dengan Amazon RDS for SQL](https://aws.amazon.com/blogs/database/implement-linked-servers-with-amazon-rds-for-microsoft-sql-server/) Server posting blog dan [Support untuk server tertaut dengan Oracle OLEDB di Amazon RDS for SQL Server dalam dokumentasi Amazon RDS](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.LinkedServers_Oracle_OLEDB.html). Versi mesin khusus (CEV) adalah snapshot volume biner dari versi database dan Amazon Machine Image (AMI). | 
| Layanan Machine Learning (dengan skrip R) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Machine Learning Services harus diinstal secara terpisah pada mesin Windows atau Linux. Ini didukung pada [Instans Cluster Always On Failover (FCI)](https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/always-on-failover-cluster-instances-sql-server?view=sql-server-ver15) hanya di SQL Server 2019 dan yang lebih baru. Meskipun R tidak didukung di Amazon RDS, Anda dapat menggunakannya di AWS (lihat posting blog [Memulai dengan R on AWS](https://aws.amazon.com/blogs/opensource/getting-started-with-r-on-amazon-web-services/)). | 
| Rencana pemeliharaan | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Amazon RDS menyediakan serangkaian fitur terpisah untuk memfasilitasi pencadangan dan pemulihan database. Untuk cadangan, Anda dapat mengonfigurasi pencadangan otomatis. | 
| Layanan Data Master | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Jika fitur ini sangat penting untuk beban kerja Anda, pertimbangkan untuk memilih Amazon RDS Custom atau Amazon. EC2 | 
| Microsoft Distributed Transaction Coordinator (MSDTC) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Lihat posting blog [Mengaktifkan dukungan transaksi terdistribusi untuk instans Amazon RDS for SQL Server yang bergabung dengan domain](https://aws.amazon.com/blogs/database/enabling-distributed-transaction-support-for-domain-joined-amazon-rds-for-sql-server-instances/). | 
| `OPENROWSET` | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| Database yang berisi sebagian | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2014 dan yang lebih baru) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2019)  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2014 dan yang lebih baru) |  | 
| Pengumpul Data Performa | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Di Amazon RDS, Anda dapat menggunakan Amazon CloudWatch, AWS CloudTrail, dan Performance Insights untuk memantau kinerja SQL Server Anda ([lihat Ikhtisar pemantauan Amazon RDS dalam dokumentasi Amazon](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MonitoringOverview.html) RDS).  | 
| Manajemen Berbasis Kebijakan | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Jika fitur ini sangat penting untuk beban kerja Anda, pertimbangkan untuk memilih Amazon RDS Custom atau Amazon. EC2 | 
| PolyBase | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya  | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Jika fitur ini sangat penting untuk beban kerja Anda, pertimbangkan untuk memilih Amazon RDS Custom atau Amazon. EC2 | 
| Parameter yang telah dikonfigurasi | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak |  | 
| Resource Governor | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Jika fitur ini sangat penting untuk beban kerja Anda, pertimbangkan untuk memilih Amazon RDS Custom atau Amazon. EC2 | 
| CLR Aman | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2016, 2019, dan 2022) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| Urutan | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2014 dan yang lebih baru) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2019) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2014 dan yang lebih baru) |  | 
| Pemicu tingkat server | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Jika fitur ini sangat penting untuk beban kerja Anda, pertimbangkan untuk memilih Amazon RDS Custom atau Amazon. EC2 | 
| Pialang Layanan | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (kecuali titik akhir) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| Fitur spasial dan lokasi | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| Agen SQL Server | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| SQL Server Analysis Services (SSAS) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2016 dan yang lebih baru) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Lihat [Support untuk SSAS di Amazon RDS for](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.SSAS.html) SQL Server dalam dokumentasi Amazon RDS. | 
| SQL Server Integration Services (SSIS) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2016 dan yang lebih baru) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Lihat [Support untuk SSIS di Amazon RDS for](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.SSIS.html) SQL Server dalam dokumentasi Amazon RDS. | 
| Layanan Pelaporan SQL Server (SSRS) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2016 dan yang lebih baru) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Lihat [Support untuk SSRS di Amazon RDS for](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.SSRS.html) SQL Server dalam dokumentasi Amazon RDS. | 
| Studio Manajemen SQL Server (SSMS) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| Asisten Migrasi SQL Server (SSMA) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| SQL Server Profiler | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (jejak sisi server dan sisi klien) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| `sqlcmd` | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| Database Peregangan | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Jika fitur ini sangat penting untuk beban kerja Anda, pertimbangkan untuk memilih Amazon RDS Custom atau Amazon. EC2 | 
| Pernyataan `THROW` | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2014 dan yang lebih baru) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2019) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2014 dan yang lebih baru) |  | 
| Titik akhir transaksi-SQL | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Semua operasi yang digunakan tidak `CREATE ENDPOINT` tersedia di Amazon RDS. Kami menyarankan Anda menginstal SQL Server pada EC2 instance untuk operasi ini.  | 
| Dukungan UTF-16 | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2014 dan yang lebih baru) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2014 dan yang lebih baru) |  | 
| Layanan Data WCF | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Jika fitur ini sangat penting untuk beban kerja Anda, pertimbangkan untuk memilih Amazon RDS Custom atau Amazon. EC2 | 

------
#### [ HA/DR ]


****  

| Fitur pengembangan | Amazon RDS | Amazon RDS Custom | Amazon EC2 | Catatan | 
| --- | --- | --- | --- | --- | 
| Selalu Pada grup ketersediaan | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (hanya untuk tujuan migrasi) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Jika Anda memerlukan grup ketersediaan Selalu Aktif yang dikelola sendiri, sebaiknya gunakan AWS Launch Wizard untuk menyederhanakan penerapan SQL Server HA pada sebuah instance. EC2 Lihat [AWS Launch Wizard SQL Server](https://docs.aws.amazon.com/launchwizard/latest/userguide/launch-wizard-sql.html) dalam AWS dokumentasi.  | 
| Selalu Pada Instans Cluster Failover () FCIs | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Anda dapat menggunakan AWS Launch Wizard untuk menyederhanakan penyebaran SQL Server FCI Anda di Amazon. EC2 Lihat [AWS Launch Wizard SQL Server](https://docs.aws.amazon.com/launchwizard/latest/userguide/launch-wizard-sql.html) dalam AWS dokumentasi.  | 
| Mencadangkan ke Amazon S3 | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Amazon RDS mendukung pencadangan dan pemulihan asli untuk database SQL Server dengan menggunakan file cadangan lengkap (file.bak) dan Amazon S3 sebagai repositori. Lihat [Mengimpor dan Mengekspor database SQL Server dalam dokumentasi](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html) Amazon RDS. | 
| Perintah `BACKUP` | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Lihat [Bagaimana cara melakukan backup asli instans Amazon RDS DB yang menjalankan SQL Server](https://aws.amazon.com/premiumsupport/knowledge-center/native-backup-rds-sql-server/)? di Pusat AWS Pengetahuan. | 
| Pencerminan basis data | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| Replikasi SQL Server | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak (berlangganan push terbatas) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Jika Anda ingin mereplikasi satu tabel di Amazon RDS, Anda juga dapat menggunakan [AWS DMS](https://aws.amazon.com/dms/)atau mengatur replika baca. | 
| Grup ketersediaan terdistribusi | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (hanya migrasi) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Jika fitur ini sangat penting untuk beban kerja Anda, pertimbangkan untuk memilih Amazon RDS Custom atau Amazon. EC2 | 
| Pengiriman log | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Untuk tujuan pemulihan bencana, Anda dapat menggunakan replika baca atau [AWS DMS](https://aws.amazon.com/dms/). | 
| Pengiriman log kustom | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Tidak berlaku |  | 
| Pencadangan otomatis terkelola | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak (memerlukan konfigurasi dan pengelolaan rencana pemeliharaan, atau menggunakan solusi pihak ketiga) | Lihat [Bekerja dengan cadangan di dokumentasi](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html) Amazon RDS. | 
| Multi-AZ dengan failover otomatis | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (replikasi berbasis penyimpanan) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (Hanya Edisi Perusahaan, dengan konfigurasi manual grup ketersediaan Selalu Aktif) | Lihat [Penerapan multi-AZ untuk Amazon RDS for SQL Server dalam dokumentasi Amazon RDS](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html). | 
| Replika baca | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2016 dan yang lebih baru) | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (dengan konfigurasi manual grup ketersediaan Selalu Aktif) |  | 
| Perintah `RESTORE` | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Lihat [Pusat AWS Pengetahuan](https://aws.amazon.com/premiumsupport/knowledge-center/native-backup-rds-sql-server/). | 

------
#### [ Scalability ]


****  

| Fitur pengembangan | Amazon RDS | Amazon RDS Custom | Amazon EC2 | Catatan | 
| --- | --- | --- | --- | --- | 
| Pemantauan dan metrik instans dan database bawaan | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak (ekspor metrik Anda sendiri ke Amazon CloudWatch atau gunakan solusi pihak ketiga) | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak (ekspor metrik Anda sendiri ke CloudWatch atau gunakan solusi pihak ketiga) | Lihat posting blog [Pantau database SQL Server Anda dengan menggunakan metrik khusus dengan Amazon CloudWatch dan AWS Systems Manager](https://aws.amazon.com/blogs/database/monitor-your-microsoft-sql-server-using-custom-metrics-with-amazon-cloudwatch-and-aws-systems-manager/). | 
| Ukuran penyimpanan yang dapat dikonfigurasi | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| Jumlah maksimum database per instance | Tergantung pada ukuran instans dan konfigurasi Multi-AZ | SQL Server maksimum (5000) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Tidak ada batasan | Lihat [Spesifikasi kapasitas maksimum untuk SQL Server](https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15) dalam dokumentasi Microsoft SQL Server. | 
| Ukuran penyimpanan maksimum instans DB | 64 TiB | 64 TiB | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Tidak ada batasan | Amazon RDS juga mendukung database tempdb pada disk lokal dengan menggunakan penyimpanan instans Non-Volatile Memory Express (). NVMe Lihat [Dukungan penyimpanan instans untuk database tempdb di Amazon RDS for](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.InstanceStore.html) SQL Server dalam dokumentasi Amazon RDS. | 
| Ukuran penyimpanan minimum dari instans DB | 20 GiB (Edisi Perusahaan, Standar, Web, dan Ekspres) | 20 GiB (Edisi Perusahaan, Standar, Web, dan Ekspres) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Tidak ada batasan |  | 
| Pengoptimal Kueri Baru | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2016 dan yang lebih baru) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2019 dan 2022) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2014 dan yang lebih baru) |  | 

------
#### [ Security ]


****  

| Fitur pengembangan | Amazon RDS | Amazon RDS Custom | Amazon EC2 | Catatan | 
| --- | --- | --- | --- | --- | 
| Penambalan perangkat lunak otomatis | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak (CEV) ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (RPEV) | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | Versi mesin khusus (CEV) adalah snapshot volume biner dari versi database dan Amazon Machine Image (AMI). Versi mesin yang disediakan RDS (RPEV) adalah default Amazon Machine Image (AMI) dan instalasi Microsoft SQL Server. | 
| Penyimpanan terenkripsi menggunakan AWS KMS | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Lihat posting blog [Mengamankan data di Amazon RDS menggunakan AWS KMS](https://aws.amazon.com/blogs/database/securing-data-in-amazon-rds-using-aws-kms-encryption/) enkripsi. | 
| Peran server | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2016 dan yang lebih baru) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2019 dan 2022) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2014 dan yang lebih baru) |  | 
| Otentikasi SQL | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| Audit SQL Server | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| SSL (enkripsi dalam perjalanan) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Lihat [Menggunakan SSL dengan instans Microsoft SQL Server DB](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Concepts.General.SSL.Using.html) dalam dokumentasi Amazon RDS. | 
| peran sysadmin | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Untuk peran tingkat server yang tidak didukung, lihat [Keamanan Microsoft SQL Server dalam](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html#SQLServer.Concepts.General.FeatureSupport.UnsupportedRoles) dokumentasi Amazon RDS. Saat Anda membuat instans RDS DB baru, pengguna master default yang Anda gunakan mendapatkan hak istimewa tertentu untuk instans DB tersebut (lihat [Hak istimewa Akun](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.MasterAccounts.html) dalam dokumentasi Amazon RDS). | 
| TDE (enkripsi saat istirahat) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (Edisi Perusahaan: 2016-2022; Edisi Standar: 2019 dan 2022) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (SQL Server 2019 dan 2022 Edisi Perusahaan, Standar, Web, dan Pengembang) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (Edisi Perusahaan: 2014-2019; Edisi Standar: 2019) | Lihat informasi tentang dukungan TDE di dokumentasi Kustom [Amazon RDS dan](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.TDE.html) [Amazon RDS.](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-reqs-limits-MS.html#custom-sqlserver-features.smk.tde) | 
| Otentikasi Windows | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 

------
#### [ Other features ]


****  

| Fitur pengembangan | Amazon RDS | Amazon RDS Custom | Amazon EC2 | Catatan | 
| --- | --- | --- | --- | --- | 
| Kemampuan untuk menginstal agen pihak ketiga | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| Kemampuan untuk mengganti nama database yang ada | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (Hanya single-AZ) | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya (tidak tersedia untuk database dalam grup ketersediaan atau diaktifkan untuk pencerminan) | Untuk penerapan multi-AZ di Amazon RDS, lihat Mengganti nama [database Microsoft SQL Server dalam penerapan Multi-AZ dalam dokumentasi](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.RenamingDB.html) Amazon RDS. | 
| Kontrol atas instans DB dan sistem operasi | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Jika fitur ini sangat penting untuk beban kerja Anda, pertimbangkan untuk memilih Amazon RDS Custom atau Amazon. EC2 | 
| Zona waktu yang diatur khusus | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya |  | 
| Putar Ulang Terdistribusi | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Layanan klien SQL Server Distributed Replay [memerlukan izin sysadmin](https://docs.microsoft.com/en-us/sql/tools/distributed-replay/distributed-replay-security?view=sql-server-ver16#sql-server-permissions), itulah sebabnya layanan ini tidak didukung di Amazon RDS. | 
| Impor data ke dalam database msdb | ![\[No\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-no.png)Tidak | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | ![\[Yes\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/icon-yes.png)Ya | Jika fitur ini sangat penting untuk beban kerja Anda, pertimbangkan untuk memilih Amazon RDS Custom atau Amazon. EC2 | 
| Metode instalasi | N/A | N/A | Amazon Machine Image (AMI) atau instalasi manual |  | 
| Edisi SQL Server | Perusahaan, Standar, Web, Ekspres | Perusahaan, Standar, Pengembang | Perusahaan, Standar, Web, Pengembang, Ekspres |  | 
| Versi SQL Server | 2016, 2017, 2019, 2022 | 2019, 2022 | 2014, 2016, 2017, 2019, 2022 |  | 

------

Untuk informasi rinci tentang fitur-fitur ini, lihat berikut ini:
+ [Produk Microsoft di AWS](https://aws.amazon.com/windows/products/)
+ [Arsitektur Referensi Direktori Aktif: Menerapkan Layanan Domain Direktori Aktif pada AWS](https://aws.amazon.com/windows/resources/whitepapers/#ad)
+ [Mengamankan Platform Microsoft di AWS](https://d1.awsstatic.com/whitepapers/aws-microsoft-platform-security.pdf)
+ [AWS Directory Service](https://aws.amazon.com/directoryservice/)
+ [https://docs.aws.amazon.com/systems-manager-automation-runbooks/latest/userguide/automation-awsec2-sqlserverdbrestore.html](https://docs.aws.amazon.com/systems-manager-automation-runbooks/latest/userguide/automation-awsec2-sqlserverdbrestore.html)(Runbook Automation AWS Systems Manager yang mengembalikan backup database SQL Server yang disimpan di Amazon S3 ke SQL Server 2017 yang berjalan pada instance Linux) EC2

## Tanggung jawab bersama
<a name="shared"></a>

Diagram berikut menunjukkan pembagian tanggung jawab antara AWS dan pengguna dalam pengelolaan fitur SQL Server dan operasi.

 ![\[Shared responsibility in the management of SQL Server features and operations\]](http://docs.aws.amazon.com/id_id/prescriptive-guidance/latest/migration-sql-server/images/shared-responsibility.png) 

Dengan AWS layanan, Anda tidak perlu khawatir tentang tugas-tugas administrasi seperti penyediaan server, patching, setup, konfigurasi, backup, atau pemulihan. AWS terus memantau cluster Anda untuk menjaga beban kerja Anda tetap aktif dan berjalan dengan penyimpanan penyembuhan diri dan penskalaan otomatis. Anda fokus pada tugas pengembangan aplikasi bernilai tinggi seperti desain skema, konstruksi kueri, dan pengoptimalan, sambil AWS menangani tugas operasional atas nama Anda.

Anda tidak perlu menyediakan infrastruktur yang berlebihan atau kurang penyediaan untuk mengakomodasi pertumbuhan aplikasi, lonjakan intermiten, dan persyaratan kinerja, atau menimbulkan biaya modal tetap, termasuk lisensi dan dukungan perangkat lunak, penyegaran perangkat keras, dan sumber daya untuk memelihara perangkat keras. AWS mengelola ini, sehingga Anda dapat menghabiskan waktu berinovasi dan membangun aplikasi baru, bukan mengelola infrastruktur.

Untuk informasi selengkapnya, lihat [Model Tanggung Jawab Bersama](https://aws.amazon.com/compliance/shared-responsibility-model/) di AWS situs web.