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.

Location

Furman Hall 109

Start Date

3-28-2020 11:00 AM

Presentation Format

Oral Only

Group Project

No

COinS
 
Mar 28th, 11:00 AM

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.