Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen
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?

Themen
DatenbankMigration und Modernisierung
Tags
Microsoft SQL ServerAllgemeine Migrationen von DatenbankenAurora PostgreSQL
Sprache
English
neohed
gefragt vor 2 Jahren834 Aufrufe
1 Antwort
0
Akzeptierte Antwort

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
beantwortet vor 2 Jahren
profile picture
EXPERTE
Giovanni Lauria
überprüft vor einem Monat
  • neohed
    vor 2 Jahren

    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
    vor 2 Jahren

    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
    vor 2 Jahren

    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
    vor 2 Jahren

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

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen

Relevanter Inhalt