How to migrate SQL Server DB to CouchDB

Question

As I'm new to CouchDB, I wanted to know different options for migrating from SQL Server DB to CouchDB. Please throw some light on this.

Answer 1

The short answer is that there is no easy way to migrate from MySQL to CouchDB. This because the logic of MySQL or any relational database engine and a NoSQL engine are completely different. So while moving data per see is not difficult the idea is how your application and your data will work in a totally new environment. The first issue is that you will need to create views so you are need to know how your data is accessed in advance. This is not a big hurdle but you need to take this into account.

Without sufficient information about your application and your current MySQL data giving you a comprehensive reply is difficult . This said you can see a rough MySQL to CouchDB logic explanation for your queries etc at

http://guide.couchdb.org/draft/cookbook.html

These resources might also be useful

http://maztravel.com/haskell/mySqlToCouchDB.html

SQL (MySQL) vs NoSQL (CouchDB)

Answer 2

Here is an article about migrating from an SQL-based server to CouchDB:

• How to Move from MySQL to CouchDB: Part 1
• How to Move from MySQL to CouchDB: Part 2