Database and Application Migration UGO
Database and Application Migration UGO
- What's New
- Service Overview
- Getting Started
-
User Guide
- Database Evaluation
- Object Migration
- SQL Statement Conversion
- Conversion Configuration
- SQL Audit
- Data Source Management
- Permissions Management
- Interconnection with CTS
- Best Practices
- Security White Paper
-
API Reference
- Before You Start
- API Types
- Calling APIs
-
API
- API Version Management
- Quota Management
- SQL Statement Conversion
- Evaluation Project
-
Migration Project
- Creating a Migration Project
- Querying Migration Projects
- Querying the Status of a Migration Project
- Checking Target Database Permissions
- Querying Permission Check Results
- Querying Migration Project Details
- Submitting Syntax Conversion of Objects
- Querying Syntax Conversion Progress of Objects
- Submitting Verification
- Querying the Verification Progress
- Downloading a Migration Error Report
- Deleting a Migration Project
- Permissions Policies and Supported Actions
- Appendixes
- SDK Reference
-
FAQs
-
Product Consulting
- Instance Freezing, Release, and Deletion
- Which Schemas in Source Databases Are Ignored for Migration?
- What Are the Differences Between Syntax Conversion and Migration & Verification in a Migration Project?
- What Are the Database Schema Changes After an Oracle Database Is Migrated to the Target Database?
- Why Cannot I Use Some Functions?
- What Is the Function of the dsc_ora_ext Schema Generated After Migration to the Target Database?
- What Should I Do If Data Collection Fails or Is Slow Due to the Small Values of Certain Oracle SGA Parameters?
- What Should I Do If Data Collection Fails and a Message SNAPSHOT TOO OLD Is Displayed?
- What Is the Mapping Between the GaussDB Versions Displayed on the UGO Console and Self-built GaussDB Versions?
- What Are VPCEP Resource Quotas?
-
Database Connections
- What Should I Do If I Cannot Connect to the Source Oracle Database During Database Evaluation Project Creation?
- What Should I Do If I Failed To Connect to the Source Database as User sys?
- How Do I Create GaussDB Databases Compatible with Source Databases?
- What Should I Do If My Database Fails to be Connected?
- SQL Server Connection Test Failed (Error Code=0, SQLState=08S01)
-
Evaluation Project
- How Do I Select a Connection Method?
- How Does UGO Collect Data from Source Databases?
- How Does UGO Check Database Permissions?
- What Are the Possible Causes for an Object Collection Failure?
- In GaussDB, How Do I Configure a Search Path If A Statement Without Schema Name Fails To Be Executed?
- What Is Native Compatibility, Conversion Compatibility, Partial Compatibility, or Incompatibility?
- What Is the Relationship Between Migration Risk (Top 10 risk SQL) and Risky SQL Summary?
- What Are Reconstruction Statistics and How Are Reconstruction Points Measured?
- What Should I Do If An Object Collection Error (Closed Connection) Is Displayed During Evaluation Project Creation?
- What Should I Do If "ErrorCode=4036" Is Displayed During Evaluation Project Creation?
- What Should I Do If "ErrorCode=17002" Is Displayed During Evaluation Project Creation?
- What Do I Do If the Assessment Task Is Connected but the Pre-check Fails?
- What Is the Impact of the Collection on the Source Database?
-
Migration Project
- Why Is There No Available Evaluation Project During Migration Project Creation?
- When Should I Use the Conversion Config Function?
- What Should I Do If SQL Modifications Failed to Be Saved During Object Correction?
- How Do I Solve ERROR: syntax error at or near "@"?
- What Are the Possible Causes for an Object Verification Failure?
- What Are the Impacts of GUC Parameter Settings of GaussDB on Migration?
- How Do I Set GaussDB GUC Parameters?
- Why Is the Number of Indexes Different After Oracle Data is Migrated to GaussDB?
- What Should I Do If There Are ctid, xc_node_id, and tableoid Columns in GaussDB?
- Why Is Data Inconsistent When SELECT Statements Without ORDER BY Are Used for Query in Distributed GaussDB?
-
Product Consulting
- Videos
- General Reference
On this page
Help Center/
Database and Application Migration UGO/
User Guide/
Object Migration/
Object Migration Implementation/
Making a Conversion Plan
Copied.
Making a Conversion Plan
Scenarios
After a migration project is created, select objects to be migrated on the conversion plan page. You can select an object or a type of objects in batches.
Constraints
- If the source database type is GoldenDB or MySQL (earlier than 8.0), there is no ROLE object in the source database. UGO does not collect ROLE objects and the number of ROLE objects is displayed as 0.
- To migrate data, you are advised to skip the trigger migration temporarily. Otherwise, triggers may change data during migration. After data is migrated, migrate the triggers.
- If Object Status of objects is Abnormal, their Conversion Status is Skip. It means that abnormal objects cannot be converted.
Prerequisites
- The project status is Ready, the target database information is correct, and the connection test is successful.
- The user connected to the target database must have the permissions to create, delete, and modify objects such as schemas, tables, programs, indexes, users, functions, and views.
Converting Specified Objects
- Log in to the UGO console.
- In the navigation pane, choose Schema Migration > Object Migration.
- Locate the project to be migrated and click Migrate in the Operation column.
Figure 1 Conversion plan
- Click Convert Specified Objects. The Convert Specified Objects dialog box is displayed.
Figure 2 Converting specified objects
- Click Download file template to download a template.
- In the Excel file, the first column indicates schema, the second column indicates object type, and the third column indicates object name. The three columns specify an object and cannot be empty.
- Click Convert Specified Objects to upload an Excel file. Identify all objects that meet the schema, object type, and object name requirements in the list with Convert displayed.
- Click Add File to upload a file where there are objects to be converted.
- The maximum size of the file is 30 MB, and the maximum number of rows is 65,535 (excluding the table header). If the content is incorrect, you can click View Error in the upload result to view the error cause. After the error is rectified, you can upload the file again.
- After the file is uploaded successfully, the conversion status of objects is automatically updated.
- Click Download file template to download a template.
Distribution Mapping of Table Objects
If the source database type is Oracle, Db2, or MySQL and the target database type is GaussDB Distributed, you can perform the following operations:
- Replicating tables: Select one or more objects and click Replicate Table above the list. The object name is suffixed with "Replicate Table".
- Modifying distribution mapping information: Locate an object whose Object Type is TABLE and click Distribution Mapping in the Object Type column. Change the distribution type to HASH or REPLICATION and click Apply. The object name is suffixed with "replicate table" or "hash (Column name)".
- Deleting distribution mapping information: Browse to a table object and click Distribution Mapping in the Object Type column. In the displayed dialog box, select Delete distributed mapping and click Apply. Distribution Mapping next to the object name will not be displayed.
NOTE:
If you select Hash, all fields that meet the data type constraints of GaussDB distribution columns are displayed.
Parent topic: Object Migration Implementation
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