How to migrate from relational database to neo4j?

[Nirmal Singh]

Hi Everyone,

I have a relational database & it has become cumbersome because of its large number of joins. So I thought to migrate to neo4j (which sound very impressing), is there any way (other than constructing nodes by programming) for migrating existing database to neo4j (like if anything could be done around XML or something)?

One major requirement is to preserve the relational integrity of relational database in neo4j after migration.

If anyone could provide a steady response will be highly appreciated. 

Thanks,

Nims

[Max De Marzi Jr.]

You can export to CSV and import using the Batch Importer.

See => http://maxdemarzi.com/2012/02/28/batch-importer-part-2/ for some pointers.

[Luanne Coutinho]

--
 
 

[Nirmal Singh]

Hi Max,

Thanks for your help.

But in provided link, author is talking about one csv for nodes and another for relations. Example too, is focused on single table (for nodes) where as second table (vouches) is analogues to relations. 

In my case there are 10-12 tables so creating a single csv for nodes will be bit difficult and unfeasible. So could you help me with the same.

Thanks,

Nirmal

[Max De Marzi Jr.]

Hi Nimal,

You can see how I put import "models/tables/node types" in this blog post => http://maxdemarzi.com/2012/07/03/graph-generator/

Regards,

Max