We have multiple sql server databases on premises and those are setup as clusters, now we have decided to migrate same in RDS, ow how to migrate clusters

0

We have multiple sql server databases on premises and those are setup as clusters, now we have decided to migrate same in RDS, ow how to migrate clusters

質問済み 2年前376ビュー
1回答
0

Amazon RDS supports Multi-AZ deployments for Microsoft SQL Server by using either SQL Server Database Mirroring (DBM) or Always On Availability Groups (AGs). Details can be found here - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html

For migrating data from your on-prem MSSQL Server to RDS MSSQL Server, you can use AWS DMS - https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html

Refer to this section specifically for using MSSQL Server as a source - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html

Refer to this section for using MSSQL Server as a target and that includes RDS MSSQL Server - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.SQLServer.html

profile pictureAWS
エキスパート
回答済み 2年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン