Best Practices - Database Migration Guide
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Best Practices

  • When the Amazon Database Migration Service (Amazon DMS) task completes the full load, Amazon DMS stops this task. You can take this opportunity to add or enable your foreign keys or constraints and triggers in your target. If your migration type is Migrate existing data and replicate ongoing changes, resume the task to pick up the cached changes.

  • When you have tasks running, you can monitor the on-premises source host, your replication instance, and your target Amazon Aurora database. Make sure that you create alarms and get notified on key metrics, such as central processing unit (CPU) utilization, freeable memory, and IOPS.

  • Before you start the Amazon DMS migration, make sure that you disables foreign keys and triggers on the target database. Additionally, make sure that your user has privileges on Amazon DMS and Amazon Relational Database Service (Amazon RDS).

  • Amazon DMS recommends to periodically monitor the exception tables using the following query:

    select STATEMENT from admin."awsdms_apply_exceptions" where TASK_NAME in ('TASK NAME')
  • Monitoring the Amazon DMS CloudWatch log for errors and warnings. In case of any problem with migration, Amazon DMS records a corresponding warning or error message in the log.

  • Set up monitoring of source and target database latency to understand the replication lag.

  • Use the Amazon DMS data validation feature to detect data issues.

  • Test the steps designed for migration to understand any unforeseen issues.

This walkthrough covers proven end-to-end steps for migrating an SAP ASE database to Amazon Aurora MySQL using Amazon DMS. The walkthrough also includes basic instructions that show how to perform a similar migration.