Moving the subscriber data to publisher database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Moving the subscriber data to publisher...

Moving the subscriber data to publisher database

Rate Topic

Display Mode

Topic Options

Author

Message

sram24_mca

Posted Thursday, April 22, 2010 8:48 PM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:14 AM
Points: 85, Visits: 342

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

- Win.

Posted Friday, April 23, 2010 1:13 AM

SSC 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

sram24_mca

Posted Friday, April 23, 2010 10:27 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:14 AM
Points: 85, Visits: 342

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

Ronzo

Posted Thursday, April 29, 2010 1:18 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:44 AM
Points: 502, Visits: 514

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 »

Permissions