Came across an instance at work, where I had to set up replication between 2 different SQL versions,
Publisher: SQL 2005 SP3
Subscriber: SQL 2008 R2
Type: Push Subscription
1) Configure Publication on the Publisher
This article doesn’t describe the steps for configuring a Publisher, assuming here the Publications are already set ( will write up another article on a later date for Publication part)
d) Connect to the Publisher using “sa” account or any other SQL account.
l) Repeat the same to set up multiple subscriptions, you can see the list of
subscriptions under “Local Subscriptions” in subscriber as well as under “Local
Publications” in the Publisher.