MS SQL upgrade method

[rhart]

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 · Accepted solution]

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

PetrH

[rhart]

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