Migration of Databases In Cloud Computing
School Name
South Carolina Governor's School for Science & Mathematics
Grade Level
12th Grade
Presentation Topic
Computer Science
Presentation Type
Mentored
Abstract
The purpose of this study was to examine the process of moving data from a physical database onto a cloud-based one. The development of technology over the past few decades has led to the utilization of cloud computing becoming a central focus in business. Due to the complexity of this process it was essential to understand the specifics of database migration. A sample MySQL database was used for this experiment, with a filze size of 200 megabytes. Microsoft has their own cloud platform (Azure) which was where the database was migrated to. After using Microsoft's Database Migration Assistant tool, an estimation for the amount of time the migration would take was acquired. Afterwards, the database was connected to Azure and its contents were able to be migrated(copied) onto a database hosted by Microsoft Azure. This process took about an hour to complete. After migrating the database to Azure, it's contents were accessible remotely through Azure's online interface. Azure has tools such as performance tracking and data encryption which can both be used in tandem to greatly strengthen the reliability of a database. Overall our experiment was a successful demo of a complicated, lengthy process. By utilizing cloud computing, business owners can acquire the convenience of online service, and reduced expenses due to less management staff being required. Beyond this point in the study, It is hoped that more time can be spent investigating the security concerns of these online databases, hopefully finding potential solutions to solve them.
Recommended Citation
Merritt, Michael, "Migration of Databases In Cloud Computing" (2020). South Carolina Junior Academy of Science. 247.
https://scholarexchange.furman.edu/scjas/2020/all/247
Location
Furman Hall 109
Start Date
3-28-2020 11:00 AM
Presentation Format
Oral Only
Group Project
No
Migration of Databases In Cloud Computing
Furman Hall 109
The purpose of this study was to examine the process of moving data from a physical database onto a cloud-based one. The development of technology over the past few decades has led to the utilization of cloud computing becoming a central focus in business. Due to the complexity of this process it was essential to understand the specifics of database migration. A sample MySQL database was used for this experiment, with a filze size of 200 megabytes. Microsoft has their own cloud platform (Azure) which was where the database was migrated to. After using Microsoft's Database Migration Assistant tool, an estimation for the amount of time the migration would take was acquired. Afterwards, the database was connected to Azure and its contents were able to be migrated(copied) onto a database hosted by Microsoft Azure. This process took about an hour to complete. After migrating the database to Azure, it's contents were accessible remotely through Azure's online interface. Azure has tools such as performance tracking and data encryption which can both be used in tandem to greatly strengthen the reliability of a database. Overall our experiment was a successful demo of a complicated, lengthy process. By utilizing cloud computing, business owners can acquire the convenience of online service, and reduced expenses due to less management staff being required. Beyond this point in the study, It is hoped that more time can be spent investigating the security concerns of these online databases, hopefully finding potential solutions to solve them.