Checking the Migration Results

Procedure

1. When the migration verification progress reaches 100%, view the migration results of PROCEDURE.

   

2. Go to the Object Correction page, select PROCEDURE, and locate an object in the object list. PROC_REQ197 is used as an example.

   

3. Click View Details in the Operation column to view the details and the SQL statements.

   

4. Use DAS to connect to ugo in the Auto-ugo-gaussdbv5-tar-1 instance.

   For details about how to connect to a DB instance, see Adding Login Information.

5. Check that there is the schema syntax_mig_schema.
6. On the Objects tab, view the stored procedure proc_req197.

   

Follow-up Operations

• You can use Data Replication Service (DRS) to migrate data online. It is a complete solution where UGO works with DRS to migrate heterogeneous databases with complex stored procedures and functions to Huawei Cloud databases. For details about how to use DRS to migrate data from the Oracle database to GaussDB, see Best Practices of Migrating Data from Oracle to GaussDB.
• After the migration is complete, test the performance of the target database.

  For details, see GaussDB Performance White Paper.