March 28, 2019 at 7:55 am
I want to upgrade SQL 2012 to SQL 2014 where the databases are configured in replication , what is the procedure to upgrade ?
March 28, 2019 at 9:55 am
Do not upgrade to 2014 if you can absolutely avoid it. The issue is that 2014 introduces a new cardinality estimation engine. However, it doesn't introduce any tools to deal with that. Those get added in 2016 (and refined in 2017 & 2019). I go into more detail here.
I'll leave it to the real experts to talk about upgrading replication.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 28, 2019 at 3:13 pm
I would think that you have to upgrade the database first to SQL 2014 and then reconfigure the replication after the upgrade. It should be that hard to reconfigure the replication. You can script out the replication as well.
March 29, 2019 at 4:43 am
Admingod - Thursday, March 28, 2019 3:13 PMI would think that you have to upgrade the database first to SQL 2014 and then reconfigure the replication after the upgrade. It should be that hard to reconfigure the replication. You can script out the replication as well.
Except, we're not going to 2014, right?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 29, 2019 at 4:51 am
Grant Fritchey - Friday, March 29, 2019 4:43 AMAdmingod - Thursday, March 28, 2019 3:13 PMI would think that you have to upgrade the database first to SQL 2014 and then reconfigure the replication after the upgrade. It should be that hard to reconfigure the replication. You can script out the replication as well.Except, we're not going to 2014, right?
:hehe:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply