MySQL to MongoDB Migration

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

Hi,
Here is a post about DB migration . Please have a look at it: https://community.talend.com/t5/Design-and-Development/complete-migration-from-oracle-to-sql-server/....

Best regards
Sabrina

[Anonymous]

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