db-migration

This project demonstrates the migration of an on-premise MySQL database to a MySQL database instance in AWS, then from this cloud database instance to another cloud database instance using AWS Database Migration Service.

The migration process involved...

1. Identifying the on-premise database workload to be migrated.

2. Identifying the cloud equivalent that would be compatible for the rehosting.

3. Exporting the on-premise databse into a sql file.

4. Creating a cloud databse instance(sourcedb-instance) with the appropriate engine or engine of choice, in this case, MySQL.

5. Creating another databse instance (targetdb-instance) to serve as the target for the cloud-to-cloud databse migration.

6. Importing the on-premise database into the sourcedb-instance through the command line.

7. Using the Database Migration Service via the management console, 3 services are then created to enable cloud-to-cloud migration of the database i.e from sourcedb-instance to targetdb-instance. These services are: Replication instance, Endpoints and Database Migration Task.

8. With these, the database is successfully migrated fron sourcedb-instance to targetdb-instance.