In this final chapter, we learned a practical approach to migrate a database from SQL to Neo4j.
We started migrating the database schema. We saw that the migration will be straightforward if we think more in terms of entities and relations (E-R)than in terms of tables and columns. In other words, if we come back to the relational model, the entities will become nodes, while the relations will become graph relationships. The attributes will become properties.
Then, we migrated the data. We started migrating entities with their attributes, and then we migrated the relations. During this task, we learned how to migrate CRUD queries from SQL to Cypher.
Finally, we migrated some complex queries used in a real-world application. We learned how to migrate searching queries (in place of
LIKE we have regular expressions in Cypher) and grouping queries.
This was the last chapter. Now, you should be able to use Cypher with any real-world application you want to develop, from design to implementation...