470,862 Members | 1,701 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,862 developers. It's quick & easy.

Any Replication Gurus?

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!


Nov 12 '05 #1
1 1273
In the Replication Center have you looked at the subscription set
definition for the tables and selected the FULL REFRESH > AUTOMATIC
options. This should refresh the entire table. Check your subscription
set information.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Cherrish Vaidiyan | last post: by
reply views Thread by Cherrish Vaidiyan | last post: by
3 posts views Thread by dlesandrini | last post: by
9 posts views Thread by David W. Fenton | last post: by
3 posts views Thread by Gert van der Kooij | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.