Automated Tool for NoSQL to SQL Migration
Shafaq Naheed Khan, Ajish Kalia, Haleh Mehdipour Dastjerdi, Nishara Nizamuddin · 2022
Choosing which database to use is one of the most important decisions an organization needs to make when working on a new microservice. When deciding on a modern database, one of the biggest decisions is to select the correct type of (relational or non-relational) database. Organizations make this decision based on the application scenario before the development starts. However, sometimes due to the changes in requirements, developers need to switch between database systems after the development starts. Switching between database systems can be a tedious and time-consuming task. In this study, we propose a tool that will automate the process of schema and data migration from MongoDB to MySQL database. The tool has been developed using Python programming language and gives users the ability to convert the database structures while maintaining the relationships between the data fashion accurately and consistently.