Automated Tool for NoSQL to SQL Migration

Document Type

Conference Proceeding

Source of Publication

2022 7th International Conference on Information Systems Engineering

Publication Date

2-26-2023

Abstract

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.

ISBN

9781450397889

Publisher

ACM

First Page

20

Last Page

23

Disciplines

Computer Sciences

Keywords

NoSQL, SQL, migration, tool, MongoDB

Indexed in Scopus

no

Open Access

no

Link to Full Text

Share

COinS