You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@couchdb.apache.org by Duy Nguyen <du...@yahoo.com> on 2009/10/28 19:12:33 UTC
Migration to CouchDB
Hi devs,
Im migrating from MySql to couchDB , but I can not find any tools to do the migration at the moment. From my knowledge, I need to convert data in MySql to JSON format then insert JSON format data into couchDB. I've look @ http://code.google.com/p/couchdb-python/ ; unfortunately, it does not provide functionality I am looking for. I've known many projects have been successfully migration to couchDB. Please give me some guidances.
Thank you.
Re: Migration to CouchDB
Posted by Dave butlerdi <bu...@gmail.com>.
If you create your views well and use SQL/XML to obtain XML output you can
then use a standard XML to Jason routine.
I have used SQL to output several documents, supplied those as input to XSLT
to format the documents and then convert to Jason.
Look at tools like NetKernel, it has an awful lot of functions to do it all
easily. I believe the address is 1060research.com.
On Fri, Oct 30, 2009 at 10:59 PM, Zachary Zolton
<za...@gmail.com>wrote:
> IMHO it's not necessarily a good idea to directly import data from an
> SQL database to CouchDB.
>
> Properly normalized data, in an SQL database, is generally
> deconstructed into many records and tables that can be JOIN'ed
> together. CouchDB on the other hand, will serve you well if you can
> manage your data as coherent, self-sufficient documents.
>
> I'm sure you can get plenty of data modeling help if you post
> questions to the User mailing list.
>
> Cheers,
> Zach
>
> On Wed, Oct 28, 2009 at 1:12 PM, Duy Nguyen <du...@yahoo.com>
> wrote:
> > Hi devs,
> > Im migrating from MySql to couchDB , but I can not find any tools to do
> the migration at the moment. From my knowledge, I need to convert data in
> MySql to JSON format then insert JSON format data into couchDB. I've look @
> http://code.google.com/p/couchdb-python/ ; unfortunately, it does not
> provide functionality I am looking for. I've known many projects have been
> successfully migration to couchDB. Please give me some guidances.
> > Thank you.
> >
> >
> >
>
--
Regards
Dave Butler
butlerdi-at-gmail-dot-com
Also on Skype as butlerdi
Get Skype here http://www.skype.com/download.html
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
Re: Migration to CouchDB
Posted by Zachary Zolton <za...@gmail.com>.
IMHO it's not necessarily a good idea to directly import data from an
SQL database to CouchDB.
Properly normalized data, in an SQL database, is generally
deconstructed into many records and tables that can be JOIN'ed
together. CouchDB on the other hand, will serve you well if you can
manage your data as coherent, self-sufficient documents.
I'm sure you can get plenty of data modeling help if you post
questions to the User mailing list.
Cheers,
Zach
On Wed, Oct 28, 2009 at 1:12 PM, Duy Nguyen <du...@yahoo.com> wrote:
> Hi devs,
> Im migrating from MySql to couchDB , but I can not find any tools to do the migration at the moment. From my knowledge, I need to convert data in MySql to JSON format then insert JSON format data into couchDB. I've look @ http://code.google.com/p/couchdb-python/ ; unfortunately, it does not provide functionality I am looking for. I've known many projects have been successfully migration to couchDB. Please give me some guidances.
> Thank you.
>
>
>