Passer au contenu
En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post
À propos de 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
    il y a 2 ans

    Please accept the answer if it was useful for you

Sujets
Base de données
Balises
Microsoft SQL ServerBase de donnéesAmazon Keyspaces
Langue
English
demandé il y a 2 ans402 vues
2 réponses
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
répondu il y a 2 ans
EXPERT
vérifié il y a 2 ans
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
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Contenus pertinents