In the research that I am working on, I need to migrate a graph database to sql to carry out tests, I am using neo4j as a tool, the information I have found is about migrating from SQL to neo4j but nothing of the opposite process.
As discussed on https://groups.google.com/g/neo4j/c/izacXMXdVcQ
"..., there is no general tool to convert a graph to tables - it's domain specific. How to you want to convert "customer" nodes? To a "Customers" table? How will you link it back to the products they've bought, what does the join table look like?
The short answer is that you have to do the work to map between these two very different data models.
However on the neo4j side you can at least do a brute force search of the graph (in Cypher or Java, your choice) to ensure you don't miss anything. What you map that to in SQL is really your choice.... "
Graph and document databases have variable schemas whereas relational database schemas are fixed. This means you'll have to define your database schema - what your data will look like, structurally - before importing this into any SQL database. The extraction can be done from Neo4j to CSV and from here, you can load your CSV file into your relational DB, but you must first define what the CSV looks like.
Here is the manual for the CSV export facility in Neo4j. Good luck! https://neo4j.com/labs/apoc/4.1/export/csv/
You can migrate graph SQL data, by restoring the whole existing backup script or relational database that you want to migrate to the new SQL platform.
- Badges
- Science topic
- Similar topics
- Mathematical Sciences
- Graphs