AWS Classroom Series – 08/Jul/2021

AWS Database Migration

• Lets setup a system for hosting a Database and then lets migrate the database to AWS RDS
• For simulating on-premise database,
  • mysql:
    • Lets create a Linux Server with mysql database
    • Lets import the employee data into the mysql database Refer Here
  • Microsoft SQL Server:
    • Lets create a windows server and install microsoft sql server
    • Lets import the Adventure works into the microsoft sql server Refer Here
    • Then migrate the Adventureworks into the AWS RDS
• Lab Setup:
  • Lets create an ubuntu instance in the AWS (on-premise instance)
  • install mysql Refer Here
  • For creating ec2 instance Refer Here
  • For providing remote access to mysql database Refer Here
  • Now launch mysql

  sudo mysql
  
  mysql> GRANT ALL ON *.* TO sqladmin@'%' IDENTIFIED BY 'India*123'
  

  • On your local machine install mysql workbench Refer Here
  • Now on the linux server clone the git repo Refer Here
  • cd into test_db folder and execute the following command mysql -u sqladmin -p < employees.sql