MS SQL Server - Bi Directional Transactional Replication in SQL Server 2005

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Bi Directional Transactional Replication in SQL Server 2005

Newish

2006-11-16, 5:20 am

Hi Everyone

Will this scenario work:

Server A: 99% of the work done on it
Server B: 1% work dont on it (only on one table say tblx)

I want to use queued transactional replication over internet from A to
B. For the lone table which is updated in B i can will use the same.
Here is the spanner in the works. There is one field in tblx which
will be updated on Server A.

Questions are:
1) Will this work as both servers will be subscribers and publishers
albeit for different publication.
2) Will this work for that single table single field update.

Thanks in advance

Newish

Sponsored Links