SQL Server 2000: N/A
SQL Server 2005: Tested
SQL Server 2008: Tested
SQL Server 2008R2: Tested
SQL Server 2012: Tested
SQL Server 2014: Tested
SQL Server 2016: Tested
SQL Server 2017: Not Tested
Author:ChillyDBA
Date: 6 Jun 2020
Get a list of replication Publications, Subscriptions and Articles
Must be run against the server hosting the Replication Distribution database
Useful for identifying databases/tables on the source server that might be involved in replication.
Further planning can then be undertaken to ensure that the relevant publications and/or subscriptions are also recreated on the migrated DB
NOTE: Replication publisher can only be +/- 2 SQL Server versions different from the publisher, so this can sometimes put a real spanner in the works :-)
GENERATE script on: n/a
EXECUTE script on: DISTRIBUTION SERVER
** There is some additional code included below, which was created on SQL Server 2008 many years ago, and which gets a slightly different set of metadata about replication. Included here for completeness
Additional Code: