Help Center/
Database and Application Migration UGO/
Best Practices/
Migrating Schemas from Oracle to GaussDB/
Object Migration/
Checking the Migration Results
Updated on 2024-09-20 GMT+08:00
Checking the Migration Results
This section uses the PROCEDURE object type as an example to describe how to confirm the migration results.
Procedure
- When the migration verification progress reaches 100%, view the migration results of PROCEDURE.
- Go to the Object Correction page, select PROCEDURE, and locate an object in the object list. PROC_REQ197 is used as an example.
- Click View Details in the Operation column to view the details and the SQL statements.
- 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.
- Check schema ugo_ete is displayed.
- On the Objects tab, view stored procedure fe0725_v5r2_670.
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 Oracle to GaussDB, see Using DRS to Migrate Data from Oracle Database to GaussDB.
- After the migration is complete, test the performance of the target database.
For details, see GaussDB Performance White Paper.
Parent topic: Object Migration
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot