Help Center/ Database and Application Migration UGO/ User Guide/ Object Migration/ Object Migration Implementation/ Correcting Objects
Updated on 2024-11-07 GMT+08:00
View PDF
Share

Correcting Objects

The modified statements will run on the target database. Do not use statements that cause the drop of other tables and object types, or statements that cause malicious activities such as consuming too much CPU, memory and other side effects over the target database.

Correcting Objects That Failed to Be Converted

  1. Log in to the UGO console.
  2. In the navigation pane, choose Schema Migration > Object Migration. The migration project list is displayed.
  3. Locate the project to be migrated and click Migrate in the Operation column. On the displayed page, click the Object Correction tab.

    Figure 1 Object correction
    • You can view the schema name, object name, object type, conversion status, and migration status.
    • You can select a filter (Object Type, Schema, Conversion Status, Migration Status, Object Name, SQL Content Includes, SQL Content Excludes, Conversion Errors Include, or Migration Errors Include) to search for objects. If you select Object Name, fuzzy search is supported. If you select SQL Content Includes or SQL Content Excludes, you can enter up to three keywords and each keyword contains up to 10 characters. If there are a large number of objects in a project, the query slows.
    • If you search for the desired object by schema, the schema name cannot contain whitespace characters.
    • Objects such as TABLE and INDEX may be split into multiple subobjects.
      • Splitting objects can control the migration sequence of multiple features of an object.
      • To view the status and content of all child objects, click View Details next to the parent object.
      • Splitting objects depends on the conversion function of UGO. If an error occurs during script parsing or conversion, objects are not split.
      • The statuses of subobjects and other objects are different.
        • If the conversion status of a parent object is Success, the conversion status its child object is also Success.
        • If the conversion status of a parent object is Failed, the conversion status of at least one child object is Failed.
        • If the conversion status of a parent object is Manual, the conversion status of at least one child object is Manual.
        • If the migration status of a parent object is Success, the migration status of its child objects is Success or Ignore.
        • If the migration status of a parent object is Failed, the migration status of at least one child object is Failed.
        • If the migration status of all child objects is Ignore, the migration status of their parent objects is also Ignore.

  4. Locate an object and click View Details in the Operation column.

    Correct management, storage, code, and job objects in sequence.

  5. View the conversion or migration error information. If any, modification suggestions are displayed.

    • Locate an object whose Conversion Status is Failed, click View Details in the Operation column to view conversion errors.
    • Locate an object whose Migration Status is Failed, click View Details in the Operation column to view migration errors.

      If the target database is GaussDB, database object names must meet start with a letter or underscore (_) and can contain letters, digits, underscores (_), dollar signs ($), and number signs (#). The length of a non-time series table cannot exceed 63 bytes, and the length of a time series table cannot exceed 53 characters.

    Figure 2 Conversion errors on the object details page

  6. Modify SQL statements.

    • Click Export SQL to export the SQL file of the target database. Exported file name: Object name.sql.
    • Click Import SQL to directly import the modified SQL file. After the SQL file is uploaded, all changes are automatically saved.
    • Compare: This switch is disabled by default. If this function is enabled, the detailed code comparison between the source and target databases is displayed. In this case, the SQL statements cannot be edited.
    • Click next to Source or Target to copy the SQL statements to the clipboard.
    • Click next to the target end to enter the full-screen editing mode. To exit the full-screen editing, click or click the edit box and press Esc.
    • Update Dependency Data: If this switch is enabled, all dependent objects will also be verified. This function is enabled by default and can be disabled.
    • Before saving the modified code, you can click Reset to clear all modifications. If the modification has been saved, you can only perform a rollback operation.
    • Click Save to save the modifications for target database code. The modification records will be generated and saved on the Modification History page.

  7. After the modification is complete, click Save to generate a modification record. Click Modification History to view historical records.

    In the Modification History area, locate the history record and click Rollback in the Operation column to roll back to the latest modification record.

  8. Click the drop-down icon next to History ID to compare the code before and after modification.

    Figure 3 Modification history

  • If you select Oracle as the source database type, DB_LINK objects can only be converted and cannot be migrated, and their migration status is Ignore by default.
  • After the modification, the conversion status or migration status of the object changes from Failed to Manual.

Updating Statements in Batches

  1. Log in to the UGO console.
  2. In the navigation pane, choose Schema Migration > Object Migration. The migration project list is displayed.
  3. Locate the project to be migrated and click Migrate in the Operation column. On the displayed page, click the Object Correction tab.
  4. Click Bulk Statement Update.

    Figure 4 Batch modification

  5. On the Search results area, locate an object and click View Details in the Operation column.

    You can view the schema name, object type, object name, split object name, conversion status, and migration status.

  6. View the conversion or migration error information. If any, modification suggestions are displayed.

    • Locate an object whose Conversion Status is Failed, click View Details in the Operation column to view conversion errors.
    • Locate an object whose Migration Status is Failed, click View Details in the Operation column to view migration errors.
    Figure 5 Object details

    Click the Object Correction tab. The SQL statements of the source and target databases are displayed.

    Click next to Source or Target to copy the SQL statements to the clipboard.

  7. Copy a SQL keyword or character string, return to the batch modification page, and configure parameters as needed/

    Figure 6 Batch modification
    Table 1 Parameter description

    Parameter

    Mandatory

    Description

    Search Type

    Yes
    • Normal: simple search text type
    • Regular Expression: regular expression search text type
      NOTE:
      • Incorrect use of regular expressions may cause unpredictable changes to SQL statements. Therefore, exercise caution when using regular expressions.
      • For details about regular expression specifications, see Java Regex.

    SQL Key Words

    Yes

    Search for keywords obtained in the Object Details page. Click View SQL in the Operation column to go to the Object Details page.

    For example, if you select Regular Expression and enter DEFAULT* as a keyword, the system searches for all target statements with the structure DEFAULT Any SQL statement.

    Error String 1

    No

    Search for migration error messages obtained in the Object Details page. Click View SQL in the Operation column to go to the Object Details page.

    Error String 2

    No

    Further search for migration error messages obtained in the Object Details page. Click View SQL in the Operation column to go to the Object Details page.
    • After the parameters are configured, click Search. Objects that meet search criteria are displayed in the lower part of the page.
    • All error strings can be viewed in Migration Errors or Conversion Errors area, as shown in Figure 5.
    • If the user connected to the target database is different from the schema owner, UGO will change the schema owner name to the username.

  8. Click Search. The objects that meet the search criteria are displayed.

    Figure 7 Search results

    You can search for objects by schema, object type, conversion status, and migration status.

    Click the content in the Match Results column to view detailed matching information.

  9. Enter the modified SQL statement in the Replace With text box and click Replace.
  10. After the replacement is complete, click Bulk Statement Update and then click the History tab. On the displayed page, view the batch replacement records.

    Figure 8 History
    Table 2 Parameter description

    Parameter

    Description

    History ID

    The number of modification times is displayed in descending order.

    Started

    Time when the modification started, for example: 2021/09/15 16:28:15 GMT+08:00

    Ended

    Time when the modification ended, for example: 2021/09/15 16:28:16 GMT+08:00

    SQL Key Words

    SQL keywords to be searched for

    Replacement SQL

    Scripts or keywords to replace the original SQL statements

    Operation
    • Roll Back: You can roll back the last modification.
    • View List: You can view the history ID, schema, object name, and object type.

      Click View SQL to view the modified SQL statement.

  11. Click View List. On the displayed History page, click View SQL in the Operation column to view the SQL statements before and after the replacement.

    Figure 9 History