At present there are two tables in the database, the main table for the order information, field include: enterprise Numbers, order no., etc.; From the table contains: order no., but does not include the enterprise Numbers, master-slave relationship table is depend on the order number as a link, for a one-to-many relationship,
Now demand is through OGG real-time synchronization of the two order data of some enterprises in the table and order detail data to another database,
The current problems are: the main table by filtering enterprise Numbers, can order data synchronization specified enterprise Numbers;
but because there is no enterprise Numbers from the table fields, unable to sync designated enterprise order detailed information,
Great god please help see, provide the solution, or solve the instance,
PS: the source database is other company's library, can't do any change in data structure,
May add enough, temporarily no, thank you!

CodePudding user response:

You put the two tables by OGG overall synchronization to target, and then on the target side do logic processing, this is feasible?