2 publishers/1 subscriber

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janet - 25 Oct 2007 01:58 GMT

I have the following scenario:

Server A; database = databaseA
Server B; database = databaseB
Server C; database = subscriberAB

Database A and B have the same tables; table name, structure.
I need to replicate all changes from databaseA and databaseB to subscriberAB.
Question: Can this be done?
Question: Is it possible to tell which server the data orginated from in the
subscriberAB database?

Reply to this Message

Hilary Cotter - 25 Oct 2007 03:50 GMT

Yes, create the articles on both publishers with the option keep the
existing table and data unchanged in the snapshot options tab.

Unless you have a column which tracks the originator server, there is no way
to know where the data came from.

Signature

RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

>I have the following scenario:
>
[quoted text clipped - 9 lines]
> the
> subscriberAB database?

Reply to this Message

Janet - 25 Oct 2007 04:16 GMT

Could I add a column to each table on each publisher that I prepopulate with
a value? Would that work? Or would I need to populate a column on the
subscriber?

> Yes, create the articles on both publishers with the option keep the
> existing table and data unchanged in the snapshot options tab.
[quoted text clipped - 15 lines]
> > the
> > subscriberAB database?

Reply to this Message