Help Center/ Database and Application Migration UGO/ Best Practices/ Migrating Schemas from Oracle to GaussDB/ Object Migration/ Creating a GaussDB Instance
Updated on 2024-09-20 GMT+08:00
Share

Creating a GaussDB Instance

Creating a VPC

  1. Log in to the console.
  2. Click in the upper left corner of the console and select the region AP-Singapore.
  3. Under the service list, choose Networking > Virtual Private Cloud.

    The VPC console is displayed.

  4. Click Create VPC.

  5. Configure parameters as needed and click Create Now.
  6. Return to the VPC list and check whether the VPC is created.

    If the VPC status becomes available, the VPC has been created.

Creating a Security Group

  1. Log in to the console.
  2. Click in the upper left corner of the console and select the region AP-Singapore.
  3. Under the service list, choose Networking > Virtual Private Cloud.

    The VPC console is displayed.

  4. In the navigation pane, choose Access Control > Security Groups.
  5. Click Create Security Group.
  6. Configure parameters as needed.

  7. Click OK.
  8. Return to the security group list and click the security group name.
  9. Click the Inbound Rules tab, and then click Add Rule.

  10. Configure an inbound rule, add the IP address of the source database, and click OK.

Creating a GaussDB Instance

  1. Log in to the console.
  2. Click in the upper left corner of the console and select the region AP-Singapore.
  3. Under the service list, choose Databases > GaussDB.
  4. In the navigation pane on the left, click Instances.
  5. Click Buy DB Instance.
  6. Configure the instance name and basic information.

  7. Configure instance specifications.

    Select small specifications for the test. You are advised to configure specifications based on service requirements in actual use.

  8. Select a VPC and security group for the instance and configure the database port.

  9. Configure password and other information.

  10. Click Next.
  11. Go to the instance list.

    If the instance status becomes available, the instance has been created.

Creating a database in the GaussDB Instance

  1. Log in to the console.
  2. Click in the upper left corner of the console and select the region AP-Singapore.
  3. Under the service list, choose Databases > Data Admin Service.
  4. In the navigation pane on the left, click Development Tool to go to the login list page.
  5. Click Add Login.
  6. On the displayed page, select the DB engine, source database, and target DB instance, enter the login username, password, and description (optional), and enable Collect Metadata Periodically and Show Executed SQL Statements.

  7. Click Test Connection.

    If a message is displayed indicating connection successful, continue with the operation. If a message is displayed indicating a connection failed and the failure cause is provided, make modifications based on the error message.

  8. Click OK.
  9. Locate the added instance, click Log In in the Operation column.

  10. Choose SQL Operation > SQL Window on the top menu bar.
  11. Run the following statement to create a database compatible with Oracle:

    ugo indicates the database name. Replace it based on the site requirements.

    CREATE DATABASE ugo DBCOMPATIBILITY 'ORA';

Parent topic: Object Migration