Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re: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.

  • Oleksii Bebych EXPERT
    a year ago

    Please accept the answer if it was useful for you

Topics
Database
Tags
Microsoft SQL ServerDatabaseAmazon Keyspaces
Language
English
asked 2 years ago395 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

EXPERT
answered 2 years ago
EXPERT
reviewed 2 years 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
answered 2 years 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.

Relevant content