Skip to main content
R
rhart16-Pearl
16-Pearl
March 1, 2022
Solved

MS SQL upgrade method

  • March 1, 2022
  • 1 reply
  • 1461 views

When upgrading the MS SQL Server from 2014 to 2017, is it possible to backup the existing SQL server and then restore the backup to the new SQL server, which is on a new VM. Does PTC provide any guidance, I couldn't find it.

Apart from upgrade-in-place, are there other methods to update the database.

Our Database Administrator doesn't see any reason it wouldn't work, but we wondered what method other people used.

Best answer by HelesicPetr

Hi @rhart 

It is common process. Export database in earlier version and then import it to a new version database.

You can read for example Upgrade guide for Windchill. 

Every Windchill upgrade contains that process. 

 

Usually restore a backup in a new version is supported by MS SQL Database. 

MS Link

HelesicPetr_0-1646140017773.png

 

PetrH

 

1 reply

HelesicPetr
HelesicPetr22-Sapphire IIAnswer
22-Sapphire II
March 1, 2022

Hi @rhart 

It is common process. Export database in earlier version and then import it to a new version database.

You can read for example Upgrade guide for Windchill. 

Every Windchill upgrade contains that process. 

 

Usually restore a backup in a new version is supported by MS SQL Database. 

MS Link

HelesicPetr_0-1646140017773.png

 

PetrH

 

    R
    rhart16-PearlAuthor
    16-Pearl
    March 1, 2022

    Exactly the answer I was looking for, perfect thank you very much

      Terms & ConditionsAccessibility statement