steps for upgrading a replicated database in an instance where the SQL scripts are going to be run manually.
- When upgrading a configuration store which is using SQL replication we recommend that a DBA be involved to oversee the process in case of replication issues.
- Replication should be ended manually before upgrading any databases.
- The GPOADmin database on each server used in replication should be upgraded manually, using the manual SQL configuration store upgrade process once replication is broken.
- Once all GPOADmin databases have been upgraded replication can be restored by following the instructions for replicating Microsoft databases. This will be a new replication on the upgraded databases.
- Re-enabling replication before all databases have been upgraded could lead to replication conflicts and partially upgraded GPOADmin databases. It is important to ensure all databases are upgraded prior to re-enabling replication.
Defect ID 540047 Improve documentation around manual database upgrade when using replicated database.
