MSSQL Replication between different SQL versions configuring Subscriptions

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
Distributor: Publisher

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)

2) Configure Subscriptions on the Subscriber
a)
1

b) Pick the Publisher
b

c)
c

d) Connect to the Publisher using “sa” account or any other SQL account.

d

e) Pick the Publication that needs to be subscribed
e

f) Pick the Distributor, in this case it is same as Publisher
f
g) Subscription database that holds the published table is picked here

g
h) Connecting to the Distributor and Subscriber, click on the ellipsis

h

h1

h2

i) Schedule the subscription to run after the snapshot SQL agent job is completed on the
Publisher.
i
i1
j) We can trigger the subscription immediately or after the snapshot is generated.
j
j1

k) Click finish and the subscription gets created with a job scheduled to run on the
Publisher.
k
k1

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.

Advertisements

About SQLKit

For almost 10 years supporting SQL versions starting 6.5 to current as an production SQL DBA and as Application admin. Interests or learning include Hadoop , MySQL, PostGRESql and SAP BASIS administration.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s