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

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

0

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?

Topics
DatabaseMigration & Modernization
Tags
Microsoft SQL ServerGeneral Database MigrationsAurora PostgreSQL
Language
English
neohed
asked 2 years ago819 views
1 Answer
0
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.

https://aws.amazon.com/blogs/database/migrate-from-sql-server-to-amazon-aurora-using-babelfish/

I hope it helps.

** Please make sure to accept the answer **

AWS
Devinder-theDBGuy
answered 2 years ago
profile picture
EXPERT
Giovanni Lauria
reviewed 22 days ago
  • neohed
    2 years 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,

  • Devinder-theDBGuy
    2 years ago

    Pl take a look https://docs.aws.amazon.com/dms/latest/oracle-to-aurora-postgresql-migration-playbook/chap-oracle-aurora-pg.tools.awssct.html or download the driver from here https://jdbc.postgresql.org/download.html

  • neohed
    2 years ago

    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...

  • Devinder-theDBGuy
    2 years ago

    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

Relevant content