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

On the navigation pane, choose Tasks.

Choose your migration task
(migrateSHschema).

Choose the Table statistics tab, shown
following.

Connect to the Amazon Redshift instance by using SQL Workbench/J, and then check
whether the database tables were successfully migrated from Oracle to Amazon Redshift
by running the SQL script shown following.

select "table", tbl_rows
from svv_table_info
where
SCHEMA = 'sh'
order by 1;

DMS uses an Amazon Redshift COPY operation to load data. By default, the
COPY command applies automatic compression whenever loading to an empty
target table. The sample data for this walkthrough is not large enough for
automatic compression to be applied. When you migrate larger data sets, COPY
will apply automatic compression.