Migrating data from Couchbase Server to MySQL


#1

Hi,

W e are dealing with a scenario where we need to migrate data from Couchbase to MySQL . I found the an existing topic Migration Issue which does talk about using Talend ETL tool or to write own code to migrate the data.

Any suggestions for the same ?

Thanks.


#2

Everything mentioned in that forum post still goes. If your data in Couchbase is already flat and denormalized, it should be pretty easy. If your data contains nested objects and/or arrays, it’s going to be more work, because you’ll have to split those into normalized tables with foreign keys, etc. I’m not sure, but Erwin DM NoSQL might be able to help you with the modeling changes.