By using AWS re:Post, you agree to the Terms of Use

SQL Server RDS migration to EC2 SQL Server

0

Hi, Has anybody ever done a migration of SQL Server from RDS to on-prem or EC2 SQL? I'm struggling to find a way to migrate the databases across. Any pointers would be much appreciated.

1 Answer
0
Accepted Answer

What exact issues are you running into? Easiest way would be to perform a native backup on to s3 and then download the backup to your ec2 or on-prem machine and restore it. Please take a a look at this blog on how to configure native backup.

https://aws.amazon.com/premiumsupport/knowledge-center/native-backup-rds-sql-server/

answered 4 months ago
  • Ah apologies, the existing backup that I tried to use was corrupt, I took a fresh backup and it has worked perfectly. Many Thanks!

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