MySQL to MongoDB Migration

One Star

MySQL to MongoDB Migration

Wish to know how I can migrate 25 GB of RDBMS data in MySQL to MongoDB. How to deal with foreign keys and other constraints. Is there any vedios, papers etc. Pl help.
Seventeen Stars

Re: MySQL to MongoDB Migration

MongoDB does not have foreign keys. You can add to the referencing object an attribute with the ObjectID of the referenced object, but this does not cause a referential relationship like in relational databases. 
Please refer to this article to get an idea what is to do:
http://stackoverflow.com/questions/6334048/foreign-keys-in-mongo
One Star

Re: MySQL to MongoDB Migration

I have gone through the information you have provide and found them very useful. Somewhere I had learnt that GUI based talend can also help in data migration. So I was curious to know how I can exploit talend for this purpose. Thank you for your reply.
Moderator

Re: MySQL to MongoDB Migration

Hi,
Here is a post about DB migration . Please have a look at it: http://www.talendforge.org/forum/viewtopic.php?id=18793.

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: MySQL to MongoDB Migration

Hi friends,
I have installed mysql and mongodb in Amazon Web Server for the migration process. How can I use talend for writing to mongodb from mysql if
1. talend BD is installed on my desktop
2. talend BD is installed in AWS.
I donot see any component for connecting to AWS. Will appreciate if I can have some tutorials. Pl help.
Thnaks,
Sushant