Help Center> Data Replication Service> Best Practices> Real-Time Synchronization> From On-Premises Oracle to DDM> Preparing for the Destination DDM Instance> Creating a Schema and Associating It with the RDS for MySQL Instance
Updated on 2024-07-15 GMT+08:00
View PDF

Creating a Schema and Associating It with the RDS for MySQL Instance

  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 Instances page, locate the required DDM instance and click Create Schema in the Operation column.
  5. On the displayed page, specify a sharding method, enter a schema name, set the number of shards, select the required DDM accounts, and click Next.

    In this example, the schema is unsharded, and the schema name is db_test.

    Currently, only data can be synchronized from Oracle to DDM. To synchronize table structures and other objects, you need to create schemas in the destination DDM instance based on table structures of the source Oracle database.