- 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
Copied.
Setting Conversion Configuration Items
Conversion configuration items directly affect the success rate of syntax conversion and migration result verification. Therefore, you need to correctly set these configuration items and select a suitable conversion plan.
Syntax Conversion Configuration
The conversion scenarios controlled by each feature parameter are different. It is difficult for users and service personnel to systematically and comprehensively understand the conversion. Multiple reworks affect migration efficiency and user experience. You can use conversion configuration to reduce the manual update configuration and quickly and accurately complete the migration. You also need to map tablespaces between the source and target database.
- Log in to the UGO console.
- In the navigation pane, choose Schema Migration > Object Migration. The migration project list is displayed.
- Locate the project to be migrated and click Migrate in the Operation column. Click Conversion Config.
- Select a value from the Baseline Template drop-down list. Create a custom conversion configuration template. For details, see Creating a Configuration Template.
- Two templates are preset: default template and maximum compatibility template.
- After you select a template, the preset values in the template are imported to the configuration item list.
- Set the configuration items based on the actual conversion scenario.
- In the Current Configuration column, move the cursor to
of each feature to view the impact of the feature. You can click View Sample to view details about the configuration information and the current configuration conversion example.
- Locate a feature and click Edit in the Operation column to modify the current configuration of the feature and click OK.
- After you import configuration parameters, the configuration status of features is Default value. If you edit the configuration of a feature, the configuration status will become Modified.
- If the custom template in your project is deleted, the template configurations are still used, but Parameter Configuration is displayed as Default value.
- In the Current Configuration column, move the cursor to
The system view and advanced package are converted based on the latest GaussDB version. If the target database is of an earlier version, the SQL statements after conversion may be incompatible.
Mapping Tablespaces
The source and target databases may have different tablespace names. Before migration, you need to map tablespaces between the source and target databases. Tablespace names of the source statement can be converted to the mapped tablespace names of the target database.
- Log in to the UGO console.
- In the navigation pane, choose Schema Migration > Object Migration. The migration project list is displayed.
- Locate a project you want to migrate and click Migrate in the Operation column. On the Conversion Config page, click Tablespace Mapping.
Figure 1 Tablespace Mapping
- Select the source and target database tablespaces from the drop-down list boxes and click Map Tablespace. The tablespaces are mapped.
- The tablespace to be mapped has been created in the target database.
- The following migration flows support the tablespace mapping function.
- From Oracle to GaussDB
- From Oracle to PostgreSQL
- You can map one tablespace of the source database to one tablespace of the target database or map multiple tablespaces of the source database to one tablespace of the target database.
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.
For any further questions, feel free to contact us through the chatbot.
Chatbot