Tell about the steps of migrating a database from on-premise to cloud (AWS).

Database migration from on-premise to AWS typically involves the following steps:

1. Assessment and Planning: Analyze the current database, data volume, availability, and performance requirements. Choose the appropriate AWS service (e.g., Amazon RDS, Aurora, or EC2 with a self-managed DB).

2. Preparing AWS Infrastructure: Create necessary resources — VPC, subnets, security groups, and configure network connectivity (VPN or Direct Connect) for secure connection to on-premise.

3. Backup and Data Export: Create a database backup or export data in a format supported by AWS.

4. Data Transfer:

   • Use AWS Database Migration Service (DMS) to minimize downtime and ensure data replication.
   • Or manual import via dumps and uploads.

5. Testing: Verify data integrity, performance, and application functionality with the new database.

6. Switching to the New Database: Update application configurations to connect to the AWS database.

7. Monitoring and Optimization: Set up CloudWatch, Performance Insights, and other tools for monitoring and optimizing database performance.

Example of using AWS DMS:

# Creating a migration task via AWS CLI
aws dms create-replication-task \
    --replication-task-identifier my-migration-task \
    --source-endpoint-arn arn:aws:dms:source-endpoint \
    --target-endpoint-arn arn:aws:dms:target-endpoint \
    --migration-type full-load-and-cdc \
    --table-mappings file://table-mappings.json

Thus, careful planning, selecting the right AWS tools, and testing after migration are key.