Showing posts with label types. Show all posts
Showing posts with label types. Show all posts

Friday, March 23, 2012

Replication Query

Dear friends

I want to know one thing in replication.I try to apply all three types of replication.in all these whenever I start initilization it is trying to drop & create database objects.I only want to only replicate data.Most of the times i am getting error like this' this particular table//view is not able to drop it's in replication'.If i am selecting no trnsfer of data & schema.Then it's giving error like that 'snapshot sequence is not correct' when synchronization.So please tell me some solution for this
Thanks in Advance
FilsonHai friend

I hope this link helpfull for u
http://docs.openlinksw.com/virtuoso/SNAPSHOT.html

Monday, March 12, 2012

Replication Option

What you are referring to is a 'conflict'. Have a look in
the latest BOL for "conflict resolution, queued updating".
There are 3 types:
(1) Publisher wins and the subscription is reinitialized
(2) Publisher wins and overwrites subscriber value
(3) Subscriber wins and overwrites publisher value
In merge replication there are more, but this is because
transactional consistency is not maintained - it works at
the row level only.
HTH,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Thanks Paul~