- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
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 **
Contenuto pertinente
- AWS UFFICIALEAggiornata un anno fa
- AWS UFFICIALEAggiornata un anno fa
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata un anno fa
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,
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
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.