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.
相關內容
AWS 官方已更新 2 年前- AWS 官方已更新 2 年前
- AWS 官方已更新 6 個月前