Hi,
I am trying to setup a 2-way txn replication from the source & destination
on SQL Server 2000 SP3.
is it possible to set up such replication (i.e 2-way) and how can i do that
?
tks & rdgs
Message posted via http://www.droptable.comYes , its possible. I thinks its queue update method in txn replication
have a look at
http://msdn2.microsoft.com/en-us/library/ms151718.aspx
http://www.sqljunkies.com/Article/D...82E6506A47.scuk
You can get better idea at replication news group.
Regards
Amish|||Yes. Depends upon what you want to do.
You can use merge, transactional with immediate updating subscriber,
transactional with queued updating subscribers, or bi-directional
transactional replication. BOL has LOTS of information on setting each of
these up.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"maxzsim via droptable.com" <u14644@.uwe> wrote in message
news:5998195cc01d6@.uwe...
> Hi,
> I am trying to setup a 2-way txn replication from the source & destination
> on SQL Server 2000 SP3.
> is it possible to set up such replication (i.e 2-way) and how can i do
> that ?
>
> tks & rdgs
> --
> Message posted via http://www.droptable.com
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment