Skip to main content
rhart16-Pearl
16-Pearl
Mar 1, 2022 10:48 AM UTC
Solved

MS SQL upgrade method

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.

HelesicPetr
HelesicPetrAnswer
22-Sapphire II
Mar 1, 2022 1:08 PM UTC

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

 

View in thread

2 replies

HelesicPetr
HelesicPetr22-Sapphire IIAnswer
22-Sapphire II
Mar 1, 2022 1:08 PM UTC

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

 

Translate
    rhart16-PearlAuthor
    16-Pearl
    Mar 1, 2022 1:12 PM UTC

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

    Translate
      Terms & ConditionsAccessibility statement