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.

2개 답변
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
전문가
MikeLim
답변함 7달 전
profile picture
전문가
검토됨 7달 전
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
답변함 7달 전
profile picture
전문가
검토됨 7달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠