Migrate SQL Server DB (outside of AWS) to Aurora DB in AWS


I've created an empty Aurora DB inside AWS.

I backed up my SQL Server DB and upload that backup to an S3 bucket.

I thought I might be able to import that SQL Server backup either into my Aurora DB or into a SQL Server instance in AWS then migrate that to Aurora... I can't see how to do this. I've tried creating an endpoint, thinking I could use that to link to the SQL Server backup file but can't see a way.

Is this possible or should I use a different approach?

1 Answer
Accepted Answer

You can not just migrate a backup from Sql Server to Aurora. There are two optins you can consider 1/ Use SCT and DMS to migrate your Sql Server database to Aurora.
There are two parts for heterogeneous migration, Schema conversion and data migration. SCT ( Schema Conversion Tool) as the name implies is a tool to convert your database objects from one db engine to another and then you can use DMS to migrate your data from Sql Server to Aurora.

https://aws.amazon.com/dms/schema-conversion-tool/ https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html

2/ Use babelfish endpoint and then use dms to migrate your data into Aurora.


I hope it helps.

** Please make sure to accept the answer **

answered 2 years ago
profile picture
reviewed 2 months ago
  • Thanks for the help. I'm trying the first approach. The SCT has connected to my SQL Server DB. I can't connect to my Aurora DB because it asks for an Amazon Aurora (PostgreSQL compatible) driver. I've looked around but cannot find this. Do you know how to download this? Thanks,

  • Great, thanks. I'm making progress, very very slowly - been at this all day. In SCT I'm on the final tab "Choose a target" I don't know what username and password I'm supposed to use. The only login credentials I have are the ones I login to AWS portal with. RDS Management Console does not let me create any users for my Aurora DB. I did associate it with IAM credentials and created an IAM user, but that has no password that I can see, only an access key that SCT doesn't seem to care about...

  • Use the credentials for the admin user that was created when you provisioned the aurora cluster.

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