topic MySQL to MongoDB Migration in Talend Studio

MySQL to MongoDB Migration

Anonymous — Sat, 16 Nov 2024 11:31:27 GMT

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.

Re: MySQL to MongoDB Migration

Anonymous — Sat, 30 Aug 2014 12:36:52 GMT

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

Re: MySQL to MongoDB Migration

Anonymous — Sun, 31 Aug 2014 05:39:51 GMT

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.

Re: MySQL to MongoDB Migration

Anonymous — Mon, 01 Sep 2014 08:38:12 GMT

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/td-p/106789.

Best regards
Sabrina

Re: MySQL to MongoDB Migration

Anonymous — Tue, 16 Sep 2014 06:43:22 GMT

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