We use SQL Replication to push information to a completely separate SQL server and database.
I am upgrading to 10.2.500.7 this weekend and I am wondering if stopping the Snapshot and Log Reader Agents during the upgrade is all that is needed, or do I need to delete the Publication setup completely and add it back once the upgrade is complete?
We have Adv Financial Reporting from Epicor that uses SQL replication to keeps it’s copy up to date and the Epicor guides all say to remove and recreate the subscriptions during upgrades like 10.2.x to 10.2.x+, but not “point” updates like 10.2.300.5 to 10.2.300.10.
I’m going to say that for safety sake, replication needs to at least be paused at a minimum during anything but a point update. It the subscription doesn’t have too many articles, it might be better to remove and recreate them in case any of those articles have schema changes in the update you are doing.