AWS RDS SQL server Instance database move to On -premise SQL server

0

Hi Team,

I'm new here and to AWS, there is an application which is related to SQL server database with 4TB database..due to some issues... we need to migrate that database from AWS RDS instance to On premise sql server alwayson..hence would like to know. what and all need to consider - 1.inorder to move RDS database to on premise server. 2.what method we need to use move that database(4TB) to on premise SQL server.

Please help and assist on this,your help much appreciated.

3개 답변
0

A consideration would be how to transport the data dump files to on-premise.
It is 4TB of large data, so even DirectConnect will take a reasonable amount of time.
It would also take a lot of time to migrate little by little while replicating using AWS DMS or other means.
I think it is essential to provide some downtime.
It is also necessary to test the migration and measure how long it will take.
If you use AWS DMS, please make sure you also have a supported version.
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.Sources.html
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.Targets.html

The following documents are best practices for migrating to RDS, but it is recommended to review them as the same considerations apply when migrating to on-premise.
https://docs.aws.amazon.com/prescriptive-guidance/latest/migration-sql-server/best-practices.html

profile picture
전문가
답변함 2년 전
전문가
검토됨 2년 전
0

As Riku mentioned, DMS is an option. If it's OK to have the DB down during the process so no change data capture is needed it's pretty simple to do.

However native SQl Server backup may be a better option for you - see https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html.

Also https://repost.aws/knowledge-center/native-backup-rds-sql-server.

전문가
답변함 2년 전
  • @skinsman, Yes learning & gaining is fine, those articles shows how to do from On premise to AWS RDS..but My case reverse option..hence seeking an advise...surely some experts might advise to conisder what & all required like permissions,best option to move the files,if exsting db anything like db enryption exists if so how this can be consider

0

still Iam seeking what would be the best steps and how to do it.

what and all do I need to check in RDS that hosting SQL server database before migrating to on premise and what is the best way to do that.

step by step instruction too seeking...as I have a No knowledge too.

답변함 2년 전
  • Hi, the best way is to gain some knowledge, starting with the approach and links that have been suggested. A bit of reading and experimentation will get you there much faster than waiting for detailed info from other people that may never come. Getting step-by-step instructions here probably isn't realistic. All the best.

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인