Syncronize Subscription after it has expired
Posted on 2009-07-02
I have a problem, we have Replication on a system, We use Sql server 2005 for our publication and Sql server 2005 express for our subscriptions. The problem we are having is that people are not always syncronizing before their subscription has expired and we need to get the data off their lap tops. I have been researching this and found a couple options.
1. I can pull a new subscription and add the database changes to it and then syncronize ( this is alot of work).
2. I can copy the tables, create new subscription, then replace the tables, however i don't really see this one working the way people think. I am scared it would delete everthing since their old data base.
So if anyone has done this and would be able to tell me how they did it or if there is something built into RMO then that would be great. Would like to do something in code so the help desk can just run it when ever this happens again.