Updated on 2023-05-29 GMT+08:00

Creating an Object Migration Task

Create an object migration task based on the created evaluation project.

Procedure

  1. Log in to the UGO console.
  2. In the navigation pane on the left, choose Schema Migration > Object Migration.
  3. Click Create Project in the upper right corner.
  4. On the Create Migration Project page, enter the required information. For details, see Table 1.

    Figure 1 Creating a migration project
    Table 1 Parameter description

    Parameter

    Description

    Project Name

    The project name must be unique. In this example, the project name is Oracle-GaussDB.

    The name must contain 5 to 50 characters, start with a letter, and end with a letter or number. Only letters, numbers, underscores (_), and hyphens (-) are allowed.

    (Optional) Exception Notification Mode

    SMN Topic

    Specifies whether to report exceptions through Simple Message Notification (SMN).

    To create an SMN topic, see Creating a Topic.

    NOTE:

    Follow-up Operations

    After the topic is created, you can add a subscription. After the subscription has been confirmed, alarm notifications will be sent to the subscription endpoint via SMN.

    Enterprise Project

    If you have been associated with an enterprise project, select the target project from the Enterprise Project drop-down list.

    You can also go to the project management console to create a project. For details about how to create a project, see Enterprise Management User Guide.

    Check Permissions

    • Select Skip Permission Check: The generated permission check report will have no content.
    • Deselect Skip Permission Check: You can select system administrator or object owner only when the target database is GaussDB.
      • System Admin: A check for system administrator permission to create objects.
      • Object Owner: A check for current user permissions to create objects.

    By default, Skip Permission Check is not selected.

    NOTE:

    To create objects in the target database, you must have certain database permissions, such as those needed for creating tables and functions. If you skip the permission check, the system does not check whether you have these permissions.

    The migration may fail due to lack of permissions when SQL statements are converted on the target database.

    Select An Evaluation Project

    Select an evaluation project from the drop-down list.

    • Target DB: The confirmed target database type is displayed, for example GaussDB Distributed.
    • Target DB Version: The confirmed target database version is displayed, for example 2.7.
    • DB Information Input Type

      Select Instance

      • DB Instance: Select a DB instance of the target database. If no DB instance is available, create one on the console.

        View DB Instance: Click View DB Instance to go to the instance list page of the target database and view instance information.

        View Unavailable Instances: Click View Unavailable Instance. A dialog box is displayed, showing the unavailable instance names and reasons.

      • DB Name: Enter the database name based on the selected target DB instance. The name contains up to 50 characters. You are advised to use a target database that is compatible with the source database.
      • User Name: Enter the username of the target database. It is recommended that the user has administrator.
      • Password: Enter the password of the target database.

      Manually Input

      • Network Type: An elastic IP address (EIP) is used to connect to the source database.

        If the target database network is restricted by the IP address whitelist, add the EIP to the target database network whitelist to ensure that UGO can connect to the target database.

        EIP in AP-Singapore: 110.238.109.54

      • Host IP Address: Enter the IP address of the target database host.
      • Host Port: Enter the port of the target database.
      • DB Name: Enter the database name. The name contains up to 50 characters.
      • User Name: Enter the username of the target database. It is recommended that the user has administrator.
      • Password: Enter the password of the target database.

    Schemas to Migrate

    • Select Select all: Select all schemas to be collected by UGO from the source database.
    • Deselect Select all: Reselect the schemas selected in the evaluation project.

    By default, Select all is selected.

    (Optional) SSL Type

    • No SSL: SSL is disabled and there may be potential security risks.
    • SSL No Auth: Transmission will be encrypted without authentication.
    • One Way SSL: The target database will be authenticated and the transmission will be encrypted.

    (Optional) Tag

    Use predefined tags in Tag Management Service (TMS). Predefined tags are visible to all service resources that support the tagging function. For details, see Tag Management Service User Guide.

    Enter a key and a value, and click Add.

    A maximum of 10 tags can be added. For details, see Managing Tags.

  5. Click Test Connection.

    • If the connection test is successful, the Create button is available.
    • If the connection test fails, an error message is displayed.

  6. Click Create in the lower right corner.
  7. After the creation is successful, click OK to go to the object migration page. The project status is Ready.