Al usar AWS re:Post, aceptas las AWS re:Post Términos de uso
AWS re:Postre: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.

Temas
Base de datos
Etiquetas
Microsoft SQL ServerAmazon KeyspacesBase de datos
Idioma
English
profile picture
Arjun Goel
preguntada hace 2 meses159 visualizaciones
2 Respuestas
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

profile picture
EXPERTO
Oleksii Bebych
respondido hace 2 meses
profile picture
EXPERTO
Artem
revisado hace un mes
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
EXPERTO
Leonid Koren
respondido hace 2 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas

Contenido relevante