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.
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
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.
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
