About a month ago, we set up merged replication for offline reporting in our test environment according to CA's techdoc. It's been running fine for a month. We understand that when we do any upgrades to either SDM or APM, we will need to blow it away and set up the replication again, because there may be new tables or modifications to tables from the upgrade. We are now upgrading APM to 14.1 on the test system, and are having difficulties deleting the publication. It is running into table locks and will not successfully delete.
What is the recommended way to blow away the subscription and publication and start over? I'm hoping there is an easy way to do this, so that we can proceed with our APM upgrade project.