Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen
AWS re:Postre:Post

Is there a service to move a database from MSSQL to MySQL (both hosted on AWS)

0

I have a database on my company's AWS server. We have hundreds but I am only concerned with two. Both are hosted on AWS. One is a MS SQL server and the other a MySQL.

I need to periodically move an entire database from MSSQL to MySQL. They are large databases so MySQL workbench and SSIS often fail due to size. ~1-2 million records. Less than 10GB data.

I have seen mentions of an Amazon service called DMS. Is there a service on Amazon that can do this? I do not need a permanent connection or sync between the two. Just 3-4 times a month to move the database.

I do not want to mention this to my Workgroup until I know it can be done. Is Data Migration Service the tool I need? Are there any other AWS solutions ?

Themen
Migration und ModernisierungDatenbank
Tags
AWS Datenbank-MigrationsdienstMicrosoft SQL ServerSQL-Migrationen
Sprache
English
AWS-User-1696748
gefragt vor 2 Jahren592 Aufrufe
3 Antworten
3

Yes, AWS Database Migration Service should be able to help with this scenario. Please refer to the below documentation to understand the supported versions, limitations, etc. I would recommend you to test it to see if covers your entire use case.

Using a Microsoft SQL Server database as a source for AWS DMS

Using a MySQL-compatible database as a target for AWS Database Migration Service

AWS
Shivam_G
beantwortet vor 2 Jahren
2

Yes, You can migrate SQL Server database to MySQL using AWS Schema Conversation Tool (SCT) & AWS Database Migration Service (DMS) . As you mentioned you only need this migration for few times a month, you may choose the migration type as 'full load of existing data' while creating the migration. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.HighLevelView.html

Here is the step by step guide (it should have similar steps for RDS MySQL ) - https://docs.aws.amazon.com/dms/latest/sbs/chap-sqlserver2aurora.html

AWS
Ravi_M
beantwortet vor 2 Jahren
1

Also checkout AWS Database Migration Workshop.

profile pictureAWS
EXPERTE
kentrad
beantwortet vor 2 Jahren

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