Transactional Replication

Question

Post reply

Transactional Replication

rogelio.vidaurri

SSCrazy

Points: 2117
More actions
December 5, 2019 at 5:34 pm

#3705055

Hello,
We currently have 5 databases being replicated bidirectionally to another SQL Server instance using SQL Replication - Transactional (via T-SQL scripts). Both instances are running SQL Server 2012 Standard. Long story short: we back up a database in instance A, and then we restore it in instance B which then will synchronize the "delta", some scripting in between.
When we affect instance A's databases those transactions go immediately to instance B's databases and vice versa.
We need to upgrade both instances to SQL Server 2017 Standard with no downtime. Could we generate this type of replication from SQL 2012 to SQL 2017? I mean, from instance A to instance C, then from instance C to instance D and finally shutting down instances A and B?
Regards

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80320 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Jeff Moden SSC Guru Points: 1003853 More actions · Answer 2

I've not checked but even if the documentation and every MVP in the world said "Yes, that'll work", I'd try it on a couple of test systems first. My recommendation is to cut to the chase and try it on a couple of test systems now.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

rogelio.vidaurri SSCrazy Points: 2117 More actions · Answer 3

I found yesterday that it could work from 2012 to 2016, and then to 2017.

We'll give it a try.