Data migration between sql and nosql databases

Nowadays, many programs and software applications are facing a constant growing of data that has to be stored and manipulated efficiently, which has proved to be a tough challenge for the rigid traditional relational SQL databases. This has increased the popularity of much less schema restricted document type NoSQL databases which are much better suited to handle large amounts of unstructured data. However, migrating data from relational to document NoSQL databases can be a challenging task, because it requires knowledge of relational schema to select an optimal migration strategy. Proposed solution to this problem - an application that utilizes schema denormalization strategy to perform automatic data migration from „MySQL“ to „MongoDB“. The automatic migration of data is performed by analyzing existing relationships between relational tables and using embedding method to store related entries as a single „MongoDB“ collection document. In this document the migration process of test „MySQL“ database to „MongoDB“ has been described in detail to provide a better understanding of how the algorithm behind proposed application works