upgrade from SQL Server 2012 to 2017

  • I would like to ask do you guys upgrade your SQL servers or do you do clean installs? I have always done clean installs on a new server however I don't know if this is the most
    effiecient method which is why I'm asking. I have a business unit that now runs SQL Server 2012 on Windows 2012 R2. The business unit wants to move to SQL Server
    2017. So I will need to migrate there production and dev server. The server they use now also runs SSAS it contains a  tabular model as well as multidimensional.  So what approach do you
    all take also do you have any advice when doing upgrades where SSAS is involved.

  • A parallel upgrade is the safest approach however I have never had a problem with upgrade in place either. I don't have SSAS though.

  • We also go for parallel upgrade instead in-place upgrade

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

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