Help Center/ Data Replication Service/ Best Practices/ Real-Time Synchronization/ From On-Premises Oracle to DDM/ Preparing for the Destination DDM Instance/ Creating Table Structures in the Destination Database
Updated on 2024-07-15 GMT+08:00
View PDF
Share

Creating Table Structures in the Destination Database

Currently, only data can be synchronized from the source Oracle database to the destination DDM instance. Source table structures and other objects cannot be synchronized, so you need to create table structures and indexes in the destination database based on the table structures of the source schema. For more details, seePrecautions.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click the service list icon on the left and choose Databases > Distributed Database Middleware.
  4. On the displayed page, enter the username and password created in Creating a DDM Account, and click Test Connection.
  5. After the connection is successful, click Log In to log in to the DDM instance.
  6. Click the db_test schema created in Creating a Schema and Associating It with the RDS for MySQL Instance.
  7. Run the following SQL statements in database db_test to create table table3 with the same structure as the source: 

    CREATE TABLE `db_test`.`table3`(
ID INT,
COL01 CHAR(100),
COL02 NCHAR(100),
PRIMARY KEY(ID));