En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

Recommendations for Migrating from Microsoft SQL Server to AWS Neptune

0

Hello, I'm currently planning a migration of our database from a Microsoft SQL Server, hosted with a third-party provider, to AWS Neptune. Given the significant differences between a traditional relational database system and a graph database like Neptune, I'm seeking advice on the best practices and tools available within AWS ecosystem to facilitate this transition.

Could anyone share insights or guidance on the following aspects?

1. Migration Tools: Are there specific AWS services or third-party tools recommended for migrating data from SQL Server to Neptune, especially tools that help with data extraction, transformation, and loading into a graph model?

2. Data Modeling: Tips on converting a relational schema to a graph model suitable for Neptune. Any common pitfalls to avoid?

3. Data Integrity and Downtime: Best practices for ensuring data integrity during the migration and strategies to minimize downtime.

4. Resources: Any documentation, tutorials, or case studies on similar migrations that could guide us through the process.

Sujets
Base de données
Balises
Microsoft SQL ServerAmazon NeptuneBase de donnéesMigrations SQL
Langue
English
svato
demandé il y a 7 mois588 vues
2 réponses
4

You can try the blog post Populating your graph in Amazon Neptune from a relational database using AWS Database Migration Service (DMS) which goes into some of your questions in detail

AWS
EXPERT
MikeLim
répondu il y a 7 mois
profile picture
EXPERT
Oleksii Bebych
vérifié il y a 7 mois
4

In addition to the documentation around Neptune's DMS integration (as mentioned by @Mike_L), there are also a set of reference architectures on GitHub that cover data modeling and other architectural patterns: https://aws-samples.github.io/aws-dbs-refarch-graph/

There's also a course on AWS SkillBuilder that covers graph data modeling: https://explore.skillbuilder.aws/learn/course/16133/data-modeling-for-amazon-neptune

profile pictureAWS
Taylor-AWS
répondu il y a 7 mois
profile picture
EXPERT
Oleksii Bebych
vérifié il y a 7 mois

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.

Instructions pour répondre aux questions

Contenus pertinents