Hi Folks, over the weekend I have been playing with an SQL Importer utility, feel free to check it out and improve it at https://svn.neo4j.org/laboratory/users/peter/sqlimport/.
Basically, you give the DDL in the form of instructions for importing tables and joining them with relationships. After that, the importer will run your import by first sucking up all the INSERT INTO- records into Neo, optimize the LuceneIndex for primary-key-lookup, and after that traverse the nodes from each table and create the foreign keys as relationships between nodes. Right now, there is (not) - no support for parsing DDL automagically - no cleanup to remove imported nodes and fields that in Neo4j are obsolete, e.g. nodes created to hold the M2M relationship tables from the RDBMS and the ID-fields imported - only one layout supported with root->subref_books->book-1 style aggregation between nodes in one table. The testcase is not yet going through clean, but I will do more refactoring and documentation (like a NeoClipse pretty picture of the resulting nodespace). Feel free to check it out and get back with comments, who knows - it might end up as a component further down the road ... /peter GTalk: neubauer.peter Skype peter.neubauer Phone +46 704 106975 LinkedIn http://www.linkedin.com/in/neubauer Twitter http://twitter.com/peterneubauer http://www.neo4j.org - New Energy for Data - The Graph Database. http://www.ops4j.org - New Energy for OSS Communities - Open Participation Software. http://www.oredev.org - Where Good Geeks Grok. Sent from Malmo, Skåne, Sweden _______________________________________________ Neo mailing list [email protected] https://lists.neo4j.org/mailman/listinfo/user
