Migrate a SQL DB to NoSQL DB

Question

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.

Answer

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

Answer

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.

Migrate a SQL DB to NoSQL DB

관련 콘텐츠