|
Home > Archive > MS SQL Server > November 2005 > transactional replication
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 |
transactional replication
|
|
| Paolo Liverani 2005-11-23, 11:23 am |
| I am trying to setup a replication between two SQL server 2000 using
transactional replication.
Each table has its records inserted/updated/modified only from one side
(either server A or server B, but not from either) except one table that has
only one field modified from server B (i.e. server B should be able to
modify only a field of that table whilst server A should be able to do
anything else execpt modify that field).
I have created a transactional replication between server A and B but
changes done on server B that particular field is not propagated back to
server A.
Any suggestion would be appreciated.
Paolo
| |
| ChrisR 2005-11-23, 11:23 am |
| You need to be using Immediate Updating replication.
--
TIA,
ChrisR
"Paolo Liverani" wrote:
> I am trying to setup a replication between two SQL server 2000 using
> transactional replication.
> Each table has its records inserted/updated/modified only from one side
> (either server A or server B, but not from either) except one table that has
> only one field modified from server B (i.e. server B should be able to
> modify only a field of that table whilst server A should be able to do
> anything else execpt modify that field).
> I have created a transactional replication between server A and B but
> changes done on server B that particular field is not propagated back to
> server A.
> Any suggestion would be appreciated.
> Paolo
>
>
>
>
| |
| Michael Cheng [MSFT] 2005-11-24, 3:23 am |
| Hi Paolo,
Welcome to use MSDN Managed Newsgroup!
Do you want bi-direction transactional replication that any update from
Server A or Server B will be transferred to the other server?
If so, here is a step-by-step article describes how to implement
bidirectional transactional replication. This article also discusses the
issues that are involved in implementing bidirectional transactional
replication.
How To Implement Bidirectional Transactional Replication
http://support.microsoft.com/?id=820675
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================
====================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
|
|
|
|
|