Data Migration from Sql to Nosql Database

The SQL databases store data differently as compared to the NoSQL databases due to their specific demands. The data stored in the relational databases is highly structured and normalized in most environments whereas the data in the NoSQL databases are mostly unstructured. This difference of the data structure helps in meeting the specific demands of these two systems. The NoSQL DBs are scalable with high availability due to the simpler data model but does not guarantee data consistency at all times. On the other hand the RDBMS systems are not easily scalable and available at the same time due to the complex data model but guarantees data consistency. This book uses CouchDB and MySQL to represent the NoSQL and standard SQL databases respectively. The aim of this book is to suggest a methodology for data migration from the RDBMS databases to the document-based NoSQL databases.