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 <[email protected]>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 <[email protected]> > 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 **********************************************************************
