﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / SQL Server 2005 / SS2K5 Replication  / Moving the subscriber data to publisher database / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Sat, 25 May 2013 05:38:12 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Moving the subscriber data to publisher database</title><link>http://www.sqlservercentral.com/Forums/Topic909132-291-1.aspx</link><description>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 off2) remove replication3) either a) backup both databases     restore the databases as the other (i.e. swap names and locations)     setup replication as it wasor 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 publisher4) let everyone on again</description><pubDate>Thu, 29 Apr 2010 13:18:24 GMT</pubDate><dc:creator>Ronzo</dc:creator></item><item><title>RE: Moving the subscriber data to publisher database</title><link>http://www.sqlservercentral.com/Forums/Topic909132-291-1.aspx</link><description>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</description><pubDate>Fri, 23 Apr 2010 10:27:12 GMT</pubDate><dc:creator>sram24_mca</dc:creator></item><item><title>RE: Moving the subscriber data to publisher database</title><link>http://www.sqlservercentral.com/Forums/Topic909132-291-1.aspx</link><description>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.</description><pubDate>Fri, 23 Apr 2010 01:13:37 GMT</pubDate><dc:creator>- Win.</dc:creator></item><item><title>Moving the subscriber data to publisher database</title><link>http://www.sqlservercentral.com/Forums/Topic909132-291-1.aspx</link><description>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.ThanksRam</description><pubDate>Thu, 22 Apr 2010 20:48:07 GMT</pubDate><dc:creator>sram24_mca</dc:creator></item></channel></rss>