Thanks a lot.

It's work ^^

On 12/6/2010 8:09 AM, Sebastien Marchand wrote:
> Hi,
>
> I must replicate 2 servers ( A -> B )
>
> But not 2 databases but 1 database with 2 schemas ^^
>
> In one database DB1 with schemas S1 and S2, S1 from server A to server 
> B ans S2 from server B to server A.
>
> Server A Server B
>
> DB1 DB1
>
> S1------------------------->S1
>
> S2<------------------------S2
>
> I can to that, but i can't add a table in the futur L
>
> It's possible or not to do that ?

You would build two replication sets. Set one originating on server A and
subscribed by server B, set two originating on server B and subscribed by
server A. Like Vick said, as long as you don't need partial table
replication, you'll be fine.

Adding tables later works the same as if you had just one origin. You need
to create a temporary set that you add those tables to, subscribe it to the
same nodes that are subscribed to the existing set and when those
subscriptions are complete, you merge the sets together.


Jan

--
Anyone who trades liberty for security deserves neither liberty nor
security. -- Benjamin Franklin