April 22, 2010 at 8:48 pm
Hello,
We have configured the replication in two different servers(Subscriber and Publisher).Now we wanted to move some articles data from subscriber database to publisher database.
How we can proceed for above task,Is there any simple method ?
Can anyone suggesst me,what are all the steps that we need to follow.
Thanks
Ram
April 23, 2010 at 1:13 am
Ram,
What type of replication you have configured?
Why u need to copy articles from Subscriber to Publisher, already Publisher will push articles to subscriber?
How is your replication configured ?
- Win.
Cheers,
- Win.
" Have a great day "
April 23, 2010 at 10:27 am
Hello,
We have configured transactional reliplication, mistakenly our users entered the data in subscriber instead of publisher.Thanks for your understanding.
Awaiting for your reply.
Thanks,
Ram
April 29, 2010 at 1:18 pm
Don't know enough to truly answer the question, but..
IF the entire database (all objects) is identical in structure, and IF all the tables are fully published, then you could:
1) kick everyone off
2) remove replication
3)
either
a) backup both databases
restore the databases as the other (i.e. swap names and locations)
setup replication as it was
or
b) point all updating applications/users at old subscriber
point read-only stuff at old publisher
setup reversed replication, i.e. old subscriber is now publisher
4) let everyone on again
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply