CODEWITHSUNDEEP
sql-servertransactional-replication
Francescomg
Francescomg

Reputation: 3

Different versions of MS SQL Server between remote ditribution Database and Publisher

I need to set up a mechanism for transactional replication with "n" publishers and a subcriber. In this way I thought of putting a single database ditribution. I would like to know if there are problems between versions of ditribution and publishers; for example, I can have a publisher created with MSSQL 2005 and distribution database created in MSSQL 2012?

Thanks,

Francesco

Upvotes: 0

Views: 1764

Answers (1)

Ben Thul
Ben Thul

Reputation: 32707

Your needs have been anticipated: MSDN documentation.

Quoting the article:

For all types of replication, the Distributor version must be no earlier than the Publisher version. (Frequently, the Distributor is the same instance as the Publisher.)

For transactional replication, a Subscriber to a transactional publication can be any version within two versions of the Publisher version.

It would seem that your topology meets the requirements. Build it in test though to make sure you don't have any surprises.

Upvotes: 1

Related Questions