Menu
AWS Database Migration Service
Step-by-Step Migration Guide (API Version 2016-01-01)

Step 10: Verify That Your Data Migration Completed Successfully

When the migration task completes, you can compare your task results with the expected results.

To compare your migration task results with the expected results

  1. On the navigation pane, choose Tasks.

  2. Choose your migration task (migratehrschema).

  3. Choose the Table statistics tab, shown following.

    
                                 Table statistics tab
  4. Connect to the Amazon Aurora instance by using SQL Workbench/J, and then check if the database tables were successfully migrated from Oracle to Aurora by running the SQL script shown following.

    Copy
    Show databases; Use HR; SELECT TABLE_NAME,TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'HR' and TABLE_TYPE='BASE TABLE' order by 1;
    
                                 Table statistics tab
  5. To verify whether the output for tables and number of rows from the preceding query matches what is expected for RDS Oracle, compare your results with those in the spreadsheet provided by AWS at this site.

  6. Run the following query to check the relationship in tables; this query checks the departments with employees greater than 10.

    Copy
    SELECT B.DEPARTMENT_NAME,COUNT(*) FROM HR.EMPLOYEES A,HR.DEPARTMENTS B WHERE A.DEPARTMENT_ID=B.DEPARTMENT_ID GROUP BY B.DEPARTMENT_NAME HAVING COUNT(*) > 10 ORDER BY 1;

    The output from this query should be similar to the following.

    Copy
    department_name count(*) Sales 34 Shipping 45

Now you have successfully completed a database migration from an Amazon RDS Oracle DB instance to Amazon Aurora.