How to migrate SQL Server database to CouchDB

Since I'm new to CouchDB I wanted to know the different options for migrating from SQL Server database to CouchDB. Please shed some light on this.

+3


source to share


4 answers


The short answer is that there is no easy way to port from MySQL to CouchDB. This is because the MySQL logic or any relational database engine and NoSQL engine are completely different. So, while moving data one view is not difficult, the idea is how your application and your data will perform in a completely new environment. The first problem is that you will need to create views, so you need to know how your data is being accessed beforehand. This is not a big hurdle, but you need to consider this.

Without enough information about your application and the current MySQL data to give you a comprehensive answer, it's hard. That said, you can see a rough MySQL to CouchDB logical explanation for your queries, etc.

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



These resources can also be helpful

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

SQL (MySQL) vs NoSQL (CouchDB)

+4


source


Here is an article on migrating from SQL Server to CouchDB:



+1


source


SQL Server and CouchDB are very different technologies. There is not one one-to-one migration path, because neither SQL nor Couch has all the features of the other.

0


source


I'm looking here for a simple solution to this question, and unfortunately I think it won't be for most people. However; it seems to me that most of the time we don't want to completely switch from SQL to NoSQL ... first it will require rewriting entire programs and interfaces.

I suppose in my case I see this as part of a long term development process. By doing so, I expect all my data to be stored in NoSQL in the future, but in the meantime, the goal is to free up larger datasets.

So, when you have SQL traffic websites - leave them anyway, you will probably have to redo them over time.

But where you create new content, and especially integrate large new datasets, do it in NoSQL.

I think I'm going anyway.

0


source







All Articles