Hi Tom

I have two schemas in different physical servers. The data structures and data are different because of poor data design.

I want to migrate data from one server to another server and then two-way sync databases.

In two-way sync, I plan to use GoldenGate and then use trigger to update the data of table. Example:

I have two tables:

Table T1(A1,B1,C1)

Table T2(A1,B1,C2)

I will add C2 to T1, and C1 to T2:

T1'(A1, B1, C1, C2, syn)
T2'(A1, B1, C1, C2, syn)

When GoldenGate synchronizes T1' to T2', I use trigger to update T2'C2 base on T2'C1
When GoldenGate synchronizes T2' to T1', I use trigger to update T1'C1 base on T1'C2

So, can I use GoldenGate to migrate exist data from T1' to T2', and then use script to sync data to reduce effort? How can I do?

Thanks.