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.
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
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.
Relevanter Inhalt
AWS OFFICIALAktualisiert vor 10 Monaten- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 3 Jahren