Migrate a SQL DB to NoSQL DB
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.
- 新しい順
- 投票が多い順
- コメントが多い順
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
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.
