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

Migrate a SQL DB to NoSQL DB

0

Hi AWS, I want to migrate data from existing SQL database to new Cassandra (NoSQL) database which we will be using for Enterprise HES application. Which is the best AWS service or in case I need to look for the same in the open-source space.

Topics
Database
Tags
Microsoft SQL ServerAmazon KeyspacesDatabase
Language
English
profile picture
Arjun Goel
asked 2 months ago147 views
2 Answers
2

You can migrate data to Amazon S3 using AWS DMS from any supported database source. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.S3.html

After that you can try tools like cqlsh https://docs.aws.amazon.com/keyspaces/latest/devguide/bulk-upload.html or DSBulk https://docs.aws.amazon.com/keyspaces/latest/devguide/dsbulk-upload.html

profile picture
EXPERT
Oleksii Bebych
answered 2 months ago
profile picture
EXPERT
Artem
reviewed a month ago
1

Amazon Keyspaces is a managed AWS service compatible with Apache Cassandra. The service is servlerless. I recommend that you will review this service if you would like to run a Cassandra workload on AWS. In order to migrate data from a relational database to Amazon Keyspaces, you can make use of the AWS Glue service. There are several relevant examples in this repository - https://github.com/aws-samples/amazon-keyspaces-examples/tree/main/scala/datastax-v4/aws-glue.

AWS
EXPERT
Leonid Koren
answered 2 months ago

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