Using replication under 8.2 on AIX 5.3. Having mixed success getting
what I want done.
Scenario: Two database servers configured with identically named
tables/columns. Currently both contain mutually exclusive sets of data.
Goal 1: Copy all rows from server A to server B such that B will now be
a superset of A.
Goal 2: Replicate all future changes on A to B so that B will continue
to be a complete superset of A.
Problem: Can't figure out, at least from docs, which mode I'm supposed
to use to get the asncap program to capture initial set (for goal 1)
and subsequent changes (goal 2).
I've tried doing cold start in attempts to do a full refresh, and
warmsi start to do subsequent, but always seem to end up with only new
data on the replicant. (Also in version 7, I believe that the "import"
utility would send rows to be replicated. Has this functionality been
bypassed in 8?)
Any clues would be extremely helpful!
Thanks,
Mike