Step 6: Validate the Schema Conversion

このページはお客様の言語に翻訳されていません。 翻訳のリクエスト

To validate the schema conversion, you compare the objects found in the Oracle and Aurora MySQL databases using SQL Workbench/J.

1. In SQL Workbench/J, choose File, then choose Connect window. Choose the RDSAuroraConnection you created in an earlier step. Click OK.

2. Run the following script to verify the number of object types and count in the HR schema in the target Aurora MySQL database. These values should match the number of objects in the source Oracle database:

   SELECT a.OBJECT_TYPE, COUNT(*)
   FROM
   (
   SELECT OBJECT_TYPE
   ,OBJECT_SCHEMA
   ,OBJECT_NAME
   FROM (
   SELECT 'TABLE' AS OBJECT_TYPE
   ,TABLE_NAME AS OBJECT_NAME
   ,TABLE_SCHEMA AS OBJECT_SCHEMA
   FROM information_schema.TABLES
   where  TABLE_TYPE='BASE TABLE'
   UNION
   SELECT 'VIEW' AS OBJECT_TYPE
   ,TABLE_NAME AS OBJECT_NAME
   ,TABLE_SCHEMA AS OBJECT_SCHEMA
   FROM information_schema.VIEWS
   UNION
   
   SELECT 'INDEX' AS OBJECT_TYPE
   ,CONCAT (
   CONSTRAINT_TYPE
   ,' : '
   ,CONSTRAINT_NAME
   ,' : '
   ,TABLE_NAME
   ) AS OBJECT_NAME
   ,TABLE_SCHEMA AS OBJECT_SCHEMA
   FROM information_schema.TABLE_CONSTRAINTS
   where constraint_type='PRIMARY KEY'
   UNION
   SELECT ROUTINE_TYPE AS OBJECT_TYPE
   ,ROUTINE_NAME AS OBJECT_NAME
   ,ROUTINE_SCHEMA AS OBJECT_SCHEMA
   FROM information_schema.ROUTINES
   UNION
   SELECT 'TRIGGER' AS OBJECT_TYPE
   ,CONCAT (
   TRIGGER_NAME
   ,' : '
   ,EVENT_OBJECT_SCHEMA
   ,' : '
   ,EVENT_OBJECT_TABLE
   ) AS OBJECT_NAME
   ,TRIGGER_SCHEMA AS OBJECT_SCHEMA
   FROM information_schema.triggers
   ) R
   WHERE R.OBJECT_SCHEMA ='HR'
   order by 1) a
   GROUP BY a.OBJECT_TYPE;

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

   OBJECT_TYPE    COUNT(*)
   INDEX           7
   PROCEDURE       2
   TABLE           7
   TRIGGER        10
   VIEW            1

   Next, run the following query to get table constraints information:

   SELECT CONSTRAINT_TYPE,COUNT(*)
   FROM information_schema.TABLE_CONSTRAINTS where constraint_schema='HR'
   GROUP BY CONSTRAINT_TYPE;

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

   CONSTRAINT_TYPE    COUNT(*)
   FOREIGN KEY        10
   PRIMARY KEY         7
   UNIQUE              7