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

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.

Topics
DatabaseMigration & ModernizationAnalyticsCompute
Tags
Microsoft SQL ServerAmazon Relational Database ServiceAmazon EC2
Language
English
rePost-User-2959740
asked 2 years ago449 views
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/

AWS
Devinder-theDBGuy
answered 2 years ago
profile picture
EXPERT
Sedat Salman
reviewed 10 months ago
  • rePost-User-2959740
    2 years 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

Relevant content