Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Moving the subscriber data to publisher database Expand / Collapse
Author
Message
Posted Thursday, April 22, 2010 8:48 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 10:49 PM
Points: 90, Visits: 388
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
Post #909132
Posted Friday, April 23, 2010 1:13 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, March 29, 2012 5:22 AM
Points: 260, Visits: 800
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 "
Post #909224
Posted Friday, April 23, 2010 10:27 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 10:49 PM
Points: 90, Visits: 388
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

Post #909659
Posted Thursday, April 29, 2010 1:18 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 1:18 PM
Points: 507, Visits: 617
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



Have Fun!

Ronzo

Post #913213
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse