Multiple Updatable Publication on the same table!!

Hi,

I have created a publication for sql server 2005 Mobile Edition subscriber,

I need to add another Publication/merge replication on the same tables,

Scenario:

-Server A and mobile devices (publication for sql server 2005 Mobile Edition subscriber)

-The same Server A send data "1 way direction" to Server B by merge replication publication.

NB: My Tables are updatble in both publications.

Any idea?

Thanks,

Tarek Ghazali

SQL Server MVP

Are you getting an error that's preventing this from happening?

Multiple Updatable Publication on the same table!!

Hi,

I have created a publication for sql server 2005 Mobile Edition subscriber,

I need to add another Publication/merge replication on the same tables,

Scenario:

-Server A and mobile devices (publication for sql server 2005 Mobile Edition subscriber)

-The same Server A send data "1 way direction" to Server B by merge replication publication.

NB: My Tables are updatble in both publications.

Any idea?

Thanks,

Tarek Ghazali

SQL Server MVP

Are you getting an error that's preventing this from happening?

Multiple snapshots on the same database.

I'd like to create multiple "replication" on the same database in order
to sync only some tables in each replication. When I try to add a
second push replication to the subscriber i got the following error:
"The subscription already exists."
Is there a way to do this?
Christian - do you have multiple publications? It sounds as though you are
setting up multiple subscriptions but to the same publication, judging by
the error message.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)